Entity Framework ExecuteSqlCommand BULK INSERT with parameter: am I doing this wrong?

Asked Oct 10 '19 at 18:06

Active Oct 10 '19 at 18:19

Viewed 283 times

My code:

dbContext.Database.ExecuteSqlCommand(
    @"BULK INSERT dbo.tblAudit FROM @FileName WITH (FIRSTROW=2, FIELDTERMINATOR='|', ROWTERMINATOR='\n')",
    new SqlParameter("@FileName", auditCsvFileName)
    );

It should perform a bulk insert from a csv file.

It throws an error

System.Data.SqlClient.SqlException: Incorrect syntax near '@FileName'

I can run this command (with the filename inserted) in SSMS without an error.

Is this an invalid use of parameters?
Does Entity Framework not support BULK INSERT as a raw SQL command?

Thanks

edited Oct 10 '19 at 18:19

marc_s

732,580
175
1,330
1,459

asked Oct 10 '19 at 18:06

Without Haste

`BULK INSERT` does not support parameters anywhere. You'll have to use textual replacement. – Jeroen Mostert Oct 10 '19 at 18:21
Possible duplicate of: https://stackoverflow.com/questions/7306616/bulk-insert-with-filename-parameter – Brandon Miller Oct 10 '19 at 18:23
Perhaps, using [Dynamic SQL](http://www.sqlservertutorial.net/sql-server-stored-procedures/sql-server-dynamic-sql/)? – Brian Oct 10 '19 at 19:09
I agree, I've duplicated [this post](https://stackoverflow.com/questions/7306616/bulk-insert-with-filename-parameter). Thanks. – Without Haste Oct 10 '19 at 19:15

Entity Framework ExecuteSqlCommand BULK INSERT with parameter: am I doing this wrong?

0 Answers0