Reading and inserting null values
by Thorgeir » Mon 01 Dec 2008 08:30
I am using Linq to read rows from one table and inserting them in another table. How can I read and insert (preserve) null values in number and date fields from the first table to the second table?
I have used Entity Developer to create the .dbml file and my classes.
- Thorgeir
- Thorgeir
- Posts: 4
- Joined: Mon 01 Dec 2008 07:01
- FREE Products
- SQL Server Tools
- SSMS Add-ins
- MySQL Tools
- Oracle Tools
- PostgreSQL Tools
- ADO.NET Providers for Databases
- ADO.NET Providers for Clouds
- ODBC Drivers for Databases
- ODBC Drivers for Clouds
-
SSIS Data Flow Components
A set of components for SQL Server Integration Services (SSIS) packages that provides easy to set up cost-effective data integration using SSIS ETL engine. Our components offer high performance data loading, convenient component editors, SQL support for cloud data sources and lots of data source specific features.
- Excel Add-ins for Databases
- Excel Add-ins for Cloud Apps
- Delphi Data Access Components
- dbExpress Drivers
- Productivity Tools
- ORM Solutions
- Data Services
-
SQL Decryptor
A free tool for restoring lost definitions and decrypting SQL procedures, functions, triggers, and views in SQL Server databases.
-
Event Profiler for SQL Server
Convenient GUI to SQL Trace for inspecting SQL Server Database Engine instance. The tool allows you to capture data about each server event.
-
Search
A FREE add-in for SQL Server Management Studio that allows you to quickly search SQL objects and data in your databases.
- SQL Formatter
-
T4 Editor
An advanced tool for Visual Studio, T4 Editor includes intellisense, syntax highlighting, code outlining and other features of a top-notch Visual Studio text editing add-in.
-
dbMonitor
The tool provides visual monitoring of your database applications. dbMonitor performs per-component tracing of database events such as commit, rollback, SQL statement execute, creating and destroying components etc.
-
Monitor
A FREE add-in for SQL Server Management Studio that allows you to track and analyse SQL Server performance.
- Developer Bundle for SQL Server
- dbForge Studio for SQL Server
- Compare Bundle for SQL Server
- Schema Compare for SQL Server
- Data Compare for SQL Server
- Data Generator for SQL Server
- Documenter for SQL Server
- Query Builder for SQL Server
-
Event Profiler for SQL Server
Convenient GUI to SQL Trace for inspecting SQL Server Database Engine instance. The tool allows you to capture data about each server event.
-
SQL Decryptor
A free tool for restoring lost definitions and decrypting SQL procedures, functions, triggers, and views in SQL Server databases.
- dbForge Fusion for SQL Server
- SQL Formatter
- Developer Bundle for SQL Server
- SQL Complete
- Source Control
- Unit Test
- Data Pump
- Index Manager
-
Search
A FREE add-in for SQL Server Management Studio that allows you to quickly search SQL objects and data in your databases.
-
Monitor
A FREE add-in for SQL Server Management Studio that allows you to track and analyze SQL Server performance.
- ODBC Driver for SQL Server
-
ODBC Driver for SQL Azure
Devart ODBC Driver for SQL Azure provides high-performance and feature-rich connectivity solution for ODBC-based applications to access SQL Azure databases directly, avoiding SQL Azure native client software, from Windows, MacOS, Linux, both 32-bit and 64-bit, directly via TCP/IP avoiding SQL Server Native Client
- ODBC Driver for Oracle
- ODBC Driver for MySQL
-
ODBC Driver for PostgreSQL
Devart ODBC Driver for PostgreSQL provides high-performance and feature-rich connectivity solution for ODBC-based applications to access PostgreSQL databases directly, avoiding PostgreSQL native client software, from from Windows, MacOS, Linux, both 32-bit and 64-bit
- ODBC Driver for Firebird
- ODBC Driver for InterBase
-
ODBC Driver for SQLite
Devart ODBC Driver for SQLite provides high-performance and feature-rich connectivity solution for ODBC-based applications to access SQLite databases directly, by linking SQLite library statically into application, from Windows, MacOS, Linux, both 32-bit and 64-bit. ODBC Driver for SQLite also provides SQLite DB encryption to protect your data from unauthorized access.
-
ODBC Driver for ASE
Devart ODBC Driver for SAP Sybase Adaptive Server Enterprise provides high-performance and feature-rich connectivity solution for ODBC-based applications to access ASE databases directly, avoiding ASE client software, from Windows, MacOS, Linux, both 32-bit and 64-bit
-
ODBC Driver for MongoDB
Devart ODBC Driver for MongoDB provides high-performance and feature-rich connectivity solution for ODBC-based applications to access MongoDB databases from Windows, MacOS, Linux. ODBC Driver for MongoDB fully supports MongoDB data types and allows using SQL queries to manipulate MongoDB data.
-
ODBC Driver for xBase
Devart ODBC Driver for xBase provides high-performance and feature-rich connectivity solution for ODBC-based applications to access FoxPro and dBase databases from Windows, MacOS, Linux.
- ODBC Driver for Salesforce
-
ODBC Driver for Salesforce MC
Devart ODBC Driver for Salesforce Marketing Cloud (formerly known as ExactTarget) provides high-performance and feature-rich connectivity solution for ODBC-based applications to access Salesforce Marketing Cloud databases from Windows, both 32-bit and 64-bit
- ODBC Driver for Dynamics CRM
- ODBC Driver for SugarCRM
- ODBC Driver for Zoho CRM
- ODBC Driver for QuickBooks
- ODBC Driver for FreshBooks
- ODBC Driver for MailChimp
- ODBC Driver for BigCommerce
- ODBC Driver for Magento
- ODBC Driver for NetSuite
-
SSIS Components for Salesforce
A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor and advanced SQL support, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.
-
SSIS Components for Dynamics CRM
A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor and advanced SQL support, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.
-
SSIS Components for Zoho CRM
A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor and advanced SQL support, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.
-
SSIS Components for SugarCRM
A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor and advanced SQL support, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.
-
SSIS Components for QuickBooks
A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor and advanced SQL support, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.
-
SSIS Components for MailChimp
A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor and advanced SQL support, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.
-
SSIS Components for Salesforce Marketing Cloud
A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor and advanced SQL support, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.
-
SSIS Components for BigCommerce
A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor and advanced SQL support, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.
-
SSIS Components for Magento
A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor and advanced SQL support, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.
-
SSIS Components for FreshBooks
A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor and advanced SQL support, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.
-
SSIS Components for Oracle
A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.
-
SSIS Components for MySQL
A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.
-
SSIS Components for PostgreSQL
A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.
-
SSIS Components for DB2
A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.
-
Excel Add-in Universal Pack
Devart Excel Add-ins Universal Pack includes Excel Add-ins that allow you to work with cloud and database data like with usual worksheets and save changes to these data back to the data source.
-
Excel Add-in Database Pack
Devart Excel Add-ins Database Pack includes Excel Add-ins that allow working with database data like with usual worksheets. It includes add-ins for DB2, MySQL, Oracle, PostgreSQL, SQL Server, SQLite.
-
Excel Add-in for Oracle
Excel add-in that allows you to connect Microsoft Excel to Oracle, quickly and easily load data from Oracle to Excel, instantly refresh data in an Excel workbook from the database, edit these data, and save them back to Oracle
-
Excel Add-in for SQL Server
Excel add-in that allows you to connect Microsoft Excel to SQL Server or SQL Azure, easily load data from SQL Server or SQL Azure to Excel, refresh data in an Excel workbook from the database, edit these data, and save them back to SQL Server
-
Excel Add-in for MySQL
Excel add-in that allows you to connect Microsoft Excel to MySQL or MariaDB, quickly load data from MySQL or MariaDB to Excel, instantly refresh data in an Excel workbook from the database, edit these data, and save them back to MySQL
-
Excel Add-in for PostgreSQL
Excel add-in that allows you to quickly and easily connect Microsoft Excel to PostgreSQL, load data from PostgreSQL to Excel, instantly refresh data in an Excel workbook from the database, edit these data, and save them back to PostgreSQL
-
Excel Add-in for SQLite
Excel add-in that you to connect Microsoft Excel to an SQLite database, quickly and easily load data from an SQLite database to Excel, instantly refresh data in an Excel workbook from the database, edit these data, and save them back to the database
-
Excel Add-in for DB2
Excel add-in that allows you to connect Microsoft Excel to DB2, quickly and easily load data from DB2 to Excel, instantly refresh data in an Excel workbook from the database, edit these data, and save them back to DB2
-
Excel Add-in Universal Pack
Devart Excel Add-ins Universal Pack includes Excel Add-ins that allow you to work with cloud and database data like with usual worksheets and save changes to these data back to the data source.
-
Excel Add-in Cloud Pack
Devart Excel Add-ins Cloud Pack includes Excel Add-ins that allow you to work with data of various cloud apps like with usual worksheets and save changes to these data back to the cloud app.
-
Excel Add-in for BigCommerce
Excel add-in that allows you to connect Microsoft Excel to BigCommerce, easily load data from BigCommerce to Excel, instantly refresh data in an Excel workbook from BigCommerce, edit these data, and save them back to BigCommerce
-
Excel Add-in for Dynamics CRM
Excel add-in that allows you to connect Microsoft Excel to Microsoft Dynamics CRM, load data from Dynamics CRM to Excel, refresh data in an Excel workbook from Dynamics CRM, edit these data, and save them back to Dynamics CRM
-
Excel Add-in for FreshBooks
Excel add-in that allows you to connect Microsoft Excel to FreshBooks, easily load data from FreshBooks to Excel, instantly refresh data in an Excel workbook from FreshBooks, edit these data, and save them back to FreshBooks
-
Excel Add-in for Freshdesk
Excel add-in that allows you to connect Microsoft Excel to Freshdesk, easily load data from Freshdesk to Excel, instantly refresh data in an Excel workbook from Freshdesk, edit these data, and save them back to Freshdesk
-
Excel Add-in for G Suite
Excel add-in that allows you to connect Microsoft Excel to G Suite, easily load data from G Suite to Excel, instantly refresh data in an Excel workbook from G Suite, edit these data, and save them back to G Suite
-
Excel Add-in for HubSpot
Excel add-in that allows you to connect Microsoft Excel to HubSpot, easily load data from HubSpot to Excel, instantly refresh data in an Excel workbook from HubSpot, edit these data, and save them back to HubSpot
-
Excel Add-in for Magento
Excel add-in that allows you to connect Microsoft Excel to Magento, quickly and easily load data from Magento to Excel, instantly refresh data in an Excel workbook from Magento, edit these data, and save them back to Magento
-
Excel Add-in for MailChimp
Excel add-in that allows you to connect Microsoft Excel to MailChimp, quickly and easily load data from MailChimp to Excel, instantly refresh data in an Excel workbook from MailChimp, edit these data, and save them back to MailChimp
-
Excel Add-in for Marketo
Excel add-in that allows you to connect Microsoft Excel to Marketo, quickly and easily load data from Marketo to Excel, instantly refresh data in an Excel workbook from Marketo, edit these data, and save them back to Marketo
-
Excel Add-in for NetSuite
Excel add-in that allows you to connect Microsoft Excel to NetSuite, quickly and easily load data from NetSuite to Excel, instantly refresh data in an Excel workbook from NetSuite, edit these data, and save them back to NetSuite
-
Excel Add-in for QuickBooks
Excel add-in that allows you to connect Microsoft Excel to QuickBooks Online, easily load data from QuickBooks to Excel, refresh data in an Excel workbook from QuickBooks, edit these data, and save them back to QuickBooks
-
Excel Add-in for Salesforce
Excel add-in that allows you to connect Microsoft Excel to Salesforce, quickly and easily load data from Salesforce to Excel, instantly refresh data in an Excel workbook from Salesforce, edit these data, and save them back to Salesforce
-
Excel Add-in for Salesforce Marketing Cloud
Excel add-in that allows you to connect Microsoft Excel to Salesforce Marketing Cloud, easily load data from Salesforce Marketing Cloud to Excel, instantly refresh data in an Excel workbook from Salesforce Marketing Cloud, edit these data, and save them back to Salesforce Marketing Cloud
-
Excel Add-in for Shopify
Excel add-in that allows you to connect Microsoft Excel to Shopify, quickly and easily load data from Shopify to Excel, instantly refresh data in an Excel workbook from Shopify, edit these data, and save them back to Shopify
-
Excel Add-in for SugarCRM
Excel add-in that allows you to connect Microsoft Excel to SugarCRM, quickly and easily load data from SugarCRM to Excel, instantly refresh data in an Excel workbook from SugarCRM, edit these data, and save them back to SugarCRM
-
Excel Add-in for Zendesk
Excel add-in that allows you to connect Microsoft Excel to Zendesk, quickly and easily load data from Zendesk to Excel, instantly refresh data in an Excel workbook from Zendesk, edit these data, and save them back to Zendesk
-
Excel Add-in for Zoho CRM
Excel add-in that allows you to connect Microsoft Excel to Zoho CRM, quickly and easily load data from Zoho CRM to Excel, instantly refresh data in an Excel workbook from Zoho CRM, edit these data, and save them back to Zoho CRM
-
EntityDAC
EntityDAC is an ORM for Delphi with LINQ support. It provides a powerful framework that allows to perform object-relational mapping of database objects to Delphi classes with full support for encapsulation, inheritance, polymorphism and other OOP features. To retrieve data from a database, LINQ is used as a database independent query engine. In addition, there is a feature-rich ORM modeling tool available – Entity Developer, that allows to create and edit your ORM models visually, and generate Delphi entity classes by this model automatically.
-
UniDAC
Universal Data Access Components (ODAC) is a powerful tool for developing cross-database client/server applications in Delphi, C++Builder, Lazarus (and Free Pascal) under Windows, Mac OS X, iOS, Android, Linux, and FreeBSD for both 32-bit and 64-bit platforms. UniDAC provides a unified interface to access popular database servers such as Oracle, Microsoft SQL Server, MySQL, InterBase, Firebird, PostgreSQL, SQLite, DB2, Microsoft Access, Advantage Database Server, Adaptive Server Enterprise, and more other databases.
-
ODAC
Being a feature-rich and high-performance library of components that provides native connectivity to Oracle from Delphi, C++Builder, Lazarus (and Free Pascal) under Windows, MacOS, iOS, Android, Linux, and FreeBSD for both 32-bit and 64-bit platforms, Oracle Data Access Components (ODAC) aims to assist programmers in developing of fast and native Oracle applications. It provides both possibility of connection to Oracle by means of native Oracle data access and directly via TCP/IP without involving Oracle Client.
-
SDAC
Being a feature-rich and high-performance library of components that provides direct and native connectivity to SQL Server from Delphi, C++Builder, Lazarus (and Free Pascal) under Windows, MacOS, iOS, Android, Linux, and FreeBSD for both 32-bit and 64-bit platforms, SQL Server Data Access Components (SDAC) aims to assist programmers in developing of fast and native SQL Server database applications. It provides both possibility of connection to SQL Server by means of native SQL Server data access and directly via TCP/IP without involving SQL Server Native Client.
-
MyDAC
Being a feature-rich and high-performance library of components that provides direct access to MySQL from Delphi, C++Builder, Lazarus (and Free Pascal) under Windows, Mac OS X, iOS, Android, Linux, and FreeBSD for both 32-bit and 64-bit platforms, MySQL Data Access Components (MyDAC) aims to assist programmers in developing of fast and native MySQL applications. It provides an additional opportunity to work with MySQL directly via TCP/IP without involving MySQL client library.
-
IBDAC
Being a feature-rich and high-performance library of components that provides native connectivity to InterBase and Firebird from Delphi, C++Builder, Lazarus (and Free Pascal) under Windows, Mac OS X, iOS, Android, Linux, and FreeBSD for both 32-bit and 64-bit platforms, InterBase and Firebird Data Access Components (IBDAC) aims to assist programmers in developing of fast and native Interbase and Firebird applications. IBDAC-based applications connect to the server directly using the InterBase or Firebird client.
-
PgDAC
Being a feature-rich and high-performance library of components that provides native connectivity to PostgreSQL from Delphi, C++Builder, Lazarus (and Free Pascal) under Windows, Mac OS X, iOS, Android, Linux, and FreeBSD for both 32-bit and 64-bit platforms, PostgreSQL Data Access Components (PgDAC) aims to assist programmers in developing of fast and native PostgreSQL applications. It provides opportunity to work with PostgreSQL directly via TCP/IP without involving PostgreSQL Client.
-
LiteDAC
Being a feature-rich and high-performance library of components that provides native connectivity to SQLite from Delphi, C++Builder, Lazarus (and Free Pascal) under Windows, Mac OS X, iOS, Android, Linux, and FreeBSD for both 32-bit and 64-bit platforms, SQLite Data Access Components (LiteDAC) aims to assist programmers in developing of fast and native SQLite applications. LiteDAC provides an opportunity to work with SQLite directly by static linking of SQLite library in an application. To protect your data from unauthorized access, LiteDAC provides a powerful and customizable SQLite Database Encryption engine.
-
VirtualDAC
VirtualDAC (formerly known as VirtualTable) consists of components - TVirtualQuery, TVirtualTable and TVirtualDataSet - that provide such capabilities as working with non-tabular data, performing SQL-queries to data in memory or to data from sources in different RDBMS'es etc., that are not available for standard data access components.
-
dbExpress Driver for Oracle
dbExpress is a database-independent layer that defines common interface to provide direct access to Oracle from Delphi and C++Builder on Windows and Mac OS X for both 32-bit and 64-bit platforms. Direct Mode allows to avoid using Oracle Client, that increases developed application performance and simplyfies deployment process.
-
dbExpress Driver for SQL Server
dbExpress is a database-independent layer that defines common interface to provide direct access to SQL Server from Delphi and C++Builder on Windows for both 32-bit and 64-bit platforms. Direct Mode allows to avoid using SQL Server Native Client, that increases developed application performance and simplyfies deployment process.
-
dbExpress Driver for MySQL
dbExpress is a database-independent layer that defines common interface to provide direct access to MySQL from Delphi and C++Builder on Windows and Mac OS X for both 32-bit and 64-bit platforms. Direct Mode allows to avoid using MySQL client library, that increases developed application performance and simplyfies deployment process.
- dbExpress Driver for InterBase and Firebird
-
dbExpress Driver for PostgreSQL
dbExpress is a database-independent layer that defines common interface to provide direct access to PostgreSQL from Delphi and C++Builder on Windows and Mac OS X for both 32-bit and 64-bit platforms. Direct Mode allows to avoid using PostgreSQL client software, that increases developed application performance and simplyfies deployment process.
-
dbExpress Driver for SQLite
dbExpress Driver for SQLite is a database-independent layer that defines common interface to provide direct access to SQLite from Delphi and C++Builder on Windows and Mac OS X for both 32-bit and 64-bit platforms. SQLite library is statically linked into developed applications, that increases application performance and simplyfies deployment process. dbExpress Driver for SQLite also has support for SQLite database encryption to protect your data from unauthorized access.
-
Code Review Bundle
Code Compare adds value to Review Assistant when tools are used together. That's why they are sold in code review bundle. Buying the bundle saves you money on both tools.
- Review Assistant
- Code Compare
-
T4 Editor
An advanced tool for Visual Studio, T4 Editor includes intellisense, syntax highlighting, code outlining and other features of a top-notch Visual Studio text editing add-in.
- SecureBridge
-
dbMonitor
The tool provides visual monitoring of your database applications. It performs per-component tracing of database events: commit, rollback, SQL statement execute, creating and destroying components, connection pooling events etc.
-
TMetric
TMetric is a time tracking web application for IT-professionals and companies. The tool will help individuals and organizations to be more productive. TMetric provides time tracking, work session monitoring, reporting tools, integrations and more.
-
Data Integration
Wizard-based integration with no effort, no coding, and no need for special knowledge, performed completely in a cloud
-
Backup
Automatic daily and anytime manual cloud backup with search, view, and export of backed up data and one-click data restore.
-
Query
Online SQL editor with visual Query Builder tool to query and manage data with SQL and view them in a grid or as charts.
-
Connect
Connectivity-as-a-service solution that provides standard OData interface to connect to various data sources.