Trigger Not Firing in LinQ to SQL Insert

#1

I have an AFTER INSERT trigger on my MSSQL 2008 database table. Using
SSMS, I can insert and the trigger fires and all is fine.

But in C#, if I use my DataContext, create an object, populate it, and
SubmitChanges() the row gets into the table but the trigger never
fires.

I need this trigger! Someone, please tell me how to get the DBML to
play nice with an after insert trigger.

Thanks.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Trigger Not Firing in LinQ to SQL Insert

ASP.net ASP.net discussions (microsoft.public.dotnet.framework.aspnet)

Trigger Not Firing in LinQ to SQL Insert - 07-08-2010 , 10:10 AM