Last post Sep 05, 2008 07:19 AM by iandroutledge
Sep 04, 2008 04:50 AM|iandroutledge|LINK
You have a groups table and a users table. Users belong to a group via a foreign key.
If you delete a group, you also might want to delete all the users in that group - does dynamic data take care of that for you?
When inserting new data, does it use transactions so that its all or nothing if there is an error?
ASP.NET 3.5 Extensions
.NET 3.5 SP1
Sep 04, 2008 11:23 AM|sjnaughton|LINK
This is realy a Linq to SQL or Linq to Entities question as the provider underlying DynamicData is where this occurs.
I know that you if you turn Cascading Deletes on (by adding ON DELETE CASCADE to the constraint on you tables relationships) in your database then Linq to SQL will do the cascading delete, see this early
Linq to SQL video by Mike Taulty on Deletes with LINQ to SQL
You could force tranaction in Linq to SQL see this video also by
Mike Taulty Transactions in LINQ to SQL
Hope this helps [:D]
Sep 05, 2008 07:19 AM|iandroutledge|LINK
Great reply, that pretty much answered my questions!