Fastmember exception: Specified argument was out of the range of valid values. Parameter name: name

fastmember outofrangeexception sqlbulkcopy

Question

I've been encountering this error Specified argument was out of the range of valid values. Parameter name: name

When im almost just copying the example here https://code.google.com/p/fast-member/

The error happens on the bcp.WriteToServer(reader), been looking for additional information but i still dont know what is causing the problem and the example is so simple... And i dont even know where the parameter named name is coming from.

My actual code is below

        using (var bcp = new SqlBulkCopy(configvalue1))
        using (var reader = ObjectReader.Create(DataToLoad, new string[]{"id","field1","field2","field3"}))
        {
            bcp.DestinationTableName = string.Format(DestinationTableFormat, DestinationDb, DestinationSchema, DestinationTable);
            bcp.BatchSize = BatchSize ?? 10000;
            bcp.WriteToServer(reader);
            bcp.Close();
        }

Can someone help?

Thanks in advance

1
3
3/13/2015 5:26:01 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

For me this was caused by a mismatch between the property names on source data object and the parameter list in the reader creation step.

class Supplier
{
    public string Code;
    public string Name;
}

// version that caused the error 
using (var rdr = ObjectReader.Create(suppliers, "code", "name"))

// compared to re-cased version to match the Supplier object property casing
using (var rdr = ObjectReader.Create(suppliers, "Code", "Name"))

I had used Re-sharper which re-case the "code" and "name" properties in the Supplier object and that meant the reader couldn't map to the properties. I left the properties in the revised case and amended the reader parameter list to match as shown in the second line.

2
2/2/2017 12:07:02 PM

Related Questions

Copying data from table1 to table2, with slightly different datatypes, names and additional column

You can use ...INSERT INTO...SELECT... statament. Try...INSERT INTO table2 (orderNumber,var3, var4, var5) SELECT orderNumber,var3, var4, var5 FROM table1
insert mysql sql sqlbulkcopy
asked by John Woo

The type or namespace name 'SqlBulkCopy' could not be found

Do you have a reference to ...System.Data.dll... in your project and do you have a ...using System.Data.SqlClient... statement in your file?
c# excel namespaces sqlbulkcopy
asked by Daniel Kelley

how to add column mapping in sqlbulkcopy in c# where column names contains White Space

found solution need to add Square brackets around the fields only where the White space involved in column name
.net sql sqlbulkcopy
asked by Pritam

SqlBulkCopy Exception Doesn't Contain Column Name

I think the short answer is no, there is no way to get SqlBulkCopy to tell you which column is causing the problem....In your case, I think you need to add your own validation to all decimal columns in your .net code. The number that is failing has 28 digits to the left of the decimal place, so any SQL column with a precision less than decimal(28, ...
.net exception sqlbulkcopy vb.net
asked by Gary Wright

Allow reading of multiple XMLfile names from folder using SQL code

You might try it like this...--You need a table to insert into CREATE TABLE dbo.XmlTarget(MyXML XML); --this is the dynamically changing filename DECLARE @FileName NVARCHAR(250) =N'X:\PathToFile\TestXml.xml'; --this is a dynamic command to allow a changing filename DECLARE @cmd NVARCHAR(MAX)= 'INSERT INTO dbo.XmlTarget(MyXML) SELECT CAST(x AS XM...
openrowset sql sqlbulkcopy tsql xml
asked by Shnugo

Trying to map a .NET string[] to a FastMember object but it's erroring/not mapping

I have never used this Library before however reviewing the GitHub source code it it requires a property to query from the source. Now on a string there isn't a property ...value... really all you have to use is the ...Length... property. Using ...Length.... Now this may be an issue with the FastMember library, where it creates a ...CallSite... acc...
.net c# fastmember sqlbulkcopy sql-server
asked by Nico

SqlBulkCopy mapping issue with fullstops in column names

You will not be able to retrieve column names with . from an excel sheet using OLEDB or ODBC. Because it is not a valid or recognizable syntax. ...'.' typically we use it to distinguish between two [schema].[table].[column] like that. ...OLEDB,ODBC Replace column name '.' char with '#'...So you need to replace your code...objbulk.ColumnMappings.Add...
c# sqlbulkcopy sql-server
asked by Azar Shaikh

Keeping Data Columns by name and removing the others within a DataTable

You can't change a collection while you are enumerating on it. You can change your code to a standard for loop with a backward indexing like this...for(int x = dataTable.Columns.Count - 1; x >= 0; x--) { DataColumn dc = dataTable.Columns[x]; if(dc.ColumnName != "Cat" && dc.ColumnName != "Dog" && dc.ColumnName != "Turtle " && dc.ColumnN...
c# datatable sqlbulkcopy
asked by Steve

the name function does not exists in the current context c# error

I presume you've added the '**Line 54' to indicate where the error is?...From your screen grab it looks like the text ...function... is present in the below though.... **line 54 function static void InsertDataIntoSQLServerUsingSQLBulkCopy(DataTable csvFileData) { using (SqlConnection dbConnection = new SqlConnection("Data Sou...
c# sqlbulkcopy
asked by d219

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

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