LINQ query IEnumerable for IEnumerable results in null c# datatable linq sqlbulkcopy

Question

Why is my LINQ query ("rows") showing up as a null when it seems like I have plenty of data ("waypoints")?

I'm doing an insert of ~20k records and rather than go through Entity Framework I've opted for SqlBulkCopy, which seems to mean I need a datatable. I'm trying to get an IEnumerable into IEnumberable as that seems to be the only way to get CopyToDataTable().

I was copying the syntax in this answer, and you can see in my debugger that I have plenty of objects in my original list but IEnumerable is null.

enter image description here

Same code, maybe easier to read:

    IEnumerable<DataRow> rows =
            (from w in waypoints.AsEnumerable()
            select w)  as IEnumerable<DataRow>;

    DataTable table = rows.CopyToDataTable();

The "rows" variable is returning as null.

1
0
5/23/2017 11:50:16 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

You are trying to typecase an IEnumerable<Waypoint> as an IEnumerable<DataRow>, which is not going to work unless your Waypoint class is derived from DataRow, which I assume it's not. The documentation for the CopyToDataTable method is pretty clear:

The parameter T of the input parameter source can only be of type DataRow or a type derived from DataRow.

You are going to have to make your data table the long way, unfortunately. Make a new blank DataTable, add columns to it's Columns collection, then add rows to it's Rows collection.

3
12/21/2013 6:51:15 PM

Related Questions

In C#, how can I enter a null value for a datatable's numeric field?

Are you sure the error doesn't occur somewhere else in your application? How dose your DataColumn even know that it contains decimal values and not strings, you do not define its DataType....Anyway the error says that the problem is a string - decimal conversion (not an is-null issue), so I think you receive an emty string "" rather than null when ...
c# insert null numeric sqlbulkcopy
asked by enzi

For the provided mysql query, there is a SQL Server similar query.

Here is an article which you will find useful:...How do I load text or csv file data into SQL Server?...It was the second result from Google when searching for "bcp load file"...EDIT:...You might be able to do your import in two steps. Load the rows from the file in to a temp table then apply a function to convert the IP strings to the binary forma...
bcp sqlbulkcopy sql-server
asked by Tony

I'm getting an InvalidOperationException error from SqlBulkCopy because I'm adding null data, yet the table has no null values.

If I understood your problem correctly......I think the problem is defining ...NULL... value in ...c# .net... and ...SQL.... The mean of ...NULL... of your programming language will not be the same in SQL. In SQL the NULL value represnt by ...System.DBNull Class...Just check How to ...Handle Null and DBNull
asp.net c# sqlbulkcopy
asked by huMpty duMpty

Datareader from LINQ Query for SqlBulkCopy

Well, basically the error say that you cannot apply the method "AsDataReader" with parameter an "IEnumerable" object because there is not such a method with this definition. If it might help, try to add in the references the DLL "System.Data.Entity" and ...System.Data.EntityClient
anonymous-types c# datareader linq sqlbulkcopy
asked by spaghettifunk

How to return result after bulkCopy.WriteToServer

There is no direct way of identifying if the process was completed successfully or not, other than to look for/catch any exceptions raised by ...WriteToServer()... method....An alternative approach might be to check the number of records in the database, and then check the number of records after the process completes - The difference being the num...
c# sqlbulkcopy sql-server sql-server-2008
asked by Kami

Table object is null after sqlbulkcopy insert

I believe the problem is you need to refresh your DB context. You open the DB context prior to doing the insert.
.net c# sql sqlbulkcopy
asked by Wjdavis5

Bind default value if excel sheet column value null in sql bulk copy upload

Your problem must be that the column allows NULLS....In case your column allows NULL and you provide a NULL value on the insert the NULL ...WILL... be inserted. If no value is provided for the column the DEFAULT will be considered....Setup your column to NOT NULL....ALTER TABLE [dbo].[tbl_HEI_student] ALTER COLUMN [Date_of_Birth] DATE NOT NULL ...H...
asp.net asp.net-mvc-4 c# sqlbulkcopy sql-server
asked by mxix

LINQ: Convert any empty string to Null

I can answer only to the very first part where you can replace all the empty string fields with the Null value using a conditional statment...public class Person { public string Sex { get; set; } public string Name { get; set; } } private static void LinQ3() { var namesList = new List<Person>(); namesList.Add(new Person() { Sex = "M...
c# linq sqlbulkcopy
asked by Sotiris

How do I Use FastMember to create a reader of an object with child object

I fixed this issue by creating an ...anonymous object... and filling it up with the values that we needed. This way you can flatten out your object and use only the properties that you need....var newObjects = customer.Records.Select(record => new { customer.Id, record.DisplayName, record.TotalCount, record.Conditions.IsActive, ...
c# fastmember idatareader sqlbulkcopy
asked by Muds

Loading CSV data using SQLServerBulkCSVFileRecord with enclosing and nulls

Interestingly, the source for SQLServerBulkCSVFileRecord has a ...comment...Both BCP and BULK INSERT considers double quotes as part of the data and throws error if any data (say "10") is to be...inserted into an numeric column. Our implementation does the same....that means you will have to parse each row in your code to unquote quoted values....A...
c# csv jdbc sqlbulkcopy sql-server
asked by user1443098

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow