Can i run sql script through linq

Question

I have a sql script file and i want to run that i can use sqlcommand for that but in my appliction im using linq. So i want to know can i run that script through linq if yes how can i do

Can you store the SQL in a proc? You can call a proc from LINQ to SQL too, in addition to ExecuteCommand. — Brian Mains
– Brian Mains, Commented Dec 2, 2010 at 16:02

marc_s · Accepted Answer · 2010-12-02 15:10:53Z

6

Use the DataContext.ExecuteCommand method to send your SQL directly to the database.

answered Dec 2, 2010 at 15:10

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

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

Comments

Daniel M · Accepted Answer · 2010-12-02 16:01:16Z

1

If your script contains multiple statements you will need to parse it and execute them one at a time using DataContext.ExecuteCommand, otherwise things wont go well. How you do this really depends on how your scripts are formatted.

answered Dec 2, 2010 at 16:01

Daniel M

1,59712 silver badges12 bronze badges

Collectives™ on Stack Overflow

Can i run sql script through linq

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related