Thanks for the speedy reply........I've tinkered a little with some other parts of my code and it's started work as it was , Really strange. I will keep what you have said in mind.
Your help is hugely appreciated Truez On Jan 23, 1:50 pm, Jonathan Pryor <[email protected]> wrote: > On Sat, 2010-01-23 at 05:37 -0800, Truezplaya wrote: > > I am currently trying to delete a car from my Db but i keep getting a > > object not attached error can anyone help? > >From the Table<T>.DeleteOnSubmit() documentation [0]: > > Disconnected entities must first be attached before they can be > deleted. > > In short, you can't do what you're doing. You can only delete an entity > which has been previously queried. > > Thus, what you need to do is this: > > db.CarDetail.DeleteAllOnSubmit( > db.CarDetail.Where(c => c.Make == makeID && > c.Year == year && > c.Model == model)); > > Alternatively: > > var car = db.CarDetail.Single(c => c.Make == makeID && > c.Year == year && > c.Model == model); > db.CarDetail.DeleteOnSubmit(car); > > - Jon > > [0]http://msdn.microsoft.com/en-us/library/bb763473.aspx -- You received this message because you are subscribed to the Google Groups "DbLinq" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/dblinq?hl=en.
