Transaction when using smo and DataContext of linq

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

shangjie.liu@micropatternusa.com - 12 Mar 2008 02:34 GMT

In the operation,it is neccessary to create a new table by smo and then
insert some data into the new table by DataContext.Executecommand().
Is it possible to implement in a transaction? If no,any adivise?
Thanks.

Reply to this Message

Marc Gravell - 12 Mar 2008 06:07 GMT

I haven't tried (I'm not a big fan of too much CREATE TABLE inside an
app [except for @ or #]), but \you could try wrapping the whole thing
in a TransactionScope... alternatively, use raw SQL to create the
table insead of SMO?

Marc

Reply to this Message

Paker Liu - 12 Mar 2008 13:03 GMT

Thanks for your reply.
I will test the case with TransactionScope and send a report about the
results later.
thank you again.
Paker Liu

>I haven't tried (I'm not a big fan of too much CREATE TABLE inside an
> app [except for @ or #]), but \you could try wrapping the whole thing
> in a TransactionScope... alternatively, use raw SQL to create the
> table insead of SMO?
>
> Marc

Reply to this Message

Rate this thread:

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...