Does Such an Event Exist?
- Does an event exist that will fire just before or just after L2S submits a SQL statement to SQL Server? I didn't see one but thought I would ask.
Thanks - Randy
Answers
Hi Randy,
As Damien has said in this related thread, we have such events for queries, but we can you use the Insert, Update, and Delete Operations which happen before the LINQ to SQL data entities are inserted, updated, and deleted.
For detail, please see
http://msdn.microsoft.com/en-us/library/bb882646.aspx
http://msdn.microsoft.com/en-us/library/bb882664.aspx
http://msdn.microsoft.com/en-us/library/bb386931.aspx
http://msdn.microsoft.com/en-us/library/bb546188.aspx
http://msdn.microsoft.com/en-us/library/bb546176.aspx
http://damieng.com/blog/2009/03/16/linq-to-sql-tips-and-tricks-1
Have a nice weekend!
Best Regards,
Lingzhi SunMSDN Subscriber Support in Forum
If you have any feedback on our support, please contact msdnmg@microsoft.com
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.- Proposed As Answer byLingzhi SunMSFT, ModeratorWednesday, November 04, 2009 12:59 AM
- Marked As Answer byLingzhi SunMSFT, ModeratorThursday, November 05, 2009 12:22 AM
All Replies
Hi Randy,
As Damien has said in this related thread, we have such events for queries, but we can you use the Insert, Update, and Delete Operations which happen before the LINQ to SQL data entities are inserted, updated, and deleted.
For detail, please see
http://msdn.microsoft.com/en-us/library/bb882646.aspx
http://msdn.microsoft.com/en-us/library/bb882664.aspx
http://msdn.microsoft.com/en-us/library/bb386931.aspx
http://msdn.microsoft.com/en-us/library/bb546188.aspx
http://msdn.microsoft.com/en-us/library/bb546176.aspx
http://damieng.com/blog/2009/03/16/linq-to-sql-tips-and-tricks-1
Have a nice weekend!
Best Regards,
Lingzhi SunMSDN Subscriber Support in Forum
If you have any feedback on our support, please contact msdnmg@microsoft.com
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.- Proposed As Answer byLingzhi SunMSFT, ModeratorWednesday, November 04, 2009 12:59 AM
- Marked As Answer byLingzhi SunMSFT, ModeratorThursday, November 05, 2009 12:22 AM
Hi Randy,
Do you need any further assistance? If so, please feel free to let me know.
Have a nice day!Best Regards,
Lingzhi SunMSDN Subscriber Support in Forum
If you have any feedback on our support, please contact msdnmg@microsoft.com
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.- Lingzhi,
Thank you. I never saw this response. It seems I don't always get emails when I get a response to a question I posted.
Randy


