Save UTF8 string by SqlBulkCopy c#

Question

I have this Sql query:

INSERT INTO myTable (myField) VALUES (N'Thermal Oxide: 0 Å to 40 μm')

and I want to exeute it by SqlBulkCopy like that:

DataTable myDataTable=myDb.getData("select top 1* from myTable").Clone();
DataRow dr = myDataTable.NewRow();  
dr["myField"] ="N'Thermal Oxide: 0 Å to 40μm'";
myDataTable.Rows.Add(dr);
this.openCon();
using (SqlBulkCopy bulkCopy = new SqlBulkCopy(con))   {
    bulkCopy.DestinationTableName = dt.TableName;
    bulkCopy.BulkCopyTimeout = 100;
    bulkCopy.WriteToServer(myDataTable);
}   this.closeCon();

It is work perfect, but my question is: where can I initilize the 'N' prefix? and maybe there is no need?

Thanks, chani

There is no need, you are right. Type conversion are handled by the ADO.Net driver. — Steve B
– Steve B, Commented Jul 10, 2012 at 10:58

Marc Gravell · Accepted Answer · 2012-07-10 11:19:40Z

1

Just:

dr["myField"] = "Thermal Oxide: 0 Å to 40μm";

The N'...' is only required for literals in TSQL; but since you are taking data (not TSQL) you do not need to worry about that. In the case of SqlBulkCopy, it will go down to the server in a raw format, not directly as TSQL.

In the more common case of an adapter or ORM, the library will either (most likely) use parameters, or it will worry about the escapting itself.

It perhaps should also be noted that adding 1 row via SqlBulkCopy is overkill. But it should work.

answered Jul 10, 2012 at 11:19

Marc Gravell

1.1m273 gold badges2.6k silver badges3k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Save UTF8 string by SqlBulkCopy c#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related