Delete Record with LINQ

[shapper]

Hello,

I have a table named Tags with the following columns: TagId and
TagValue.
How can I delete a record, using LINQ, given the TagId value.

Thanks,
Miguel

 

[Michael Nemtsev]

just create the var of your record u need to delete
like var myItemToDel = GetRecordToDelete();
and then use .DeleteOnSubmit(myItemToDel)

 

[shapper]

just create the var of your record u need to delete
like var myItemToDel = GetRecordToDelete();
and then use .DeleteOnSubmit(myItemToDel)
--
WBR, Michael Nemtsev [.NET/C# MVP].
Blog:http://spaces.live.com/laflour

Hello,

I have a table named Tags with the following columns: TagId and
TagValue.
How can I delete a record, using LINQ, given the TagId value.

Thanks,
Miguel

Hi,

I am using the following:

Dim database As New UndefinedDataContext
Dim tag As Tag = From t In database.Tags _
Where t.TagID = New Guid("5f8f46cc-709c-
dc11-8760-000e35bd65c3")
database.Tags.Remove(Tag)

But this is not working. I am using a fixed Guid just for testing.
I am using VB.NET but I understand C# so any suggestion can be in C#.

Thanks,
Miguel

 

[Marc Gravell]

Well, trying something similar on Northwind and using the RTM tools:

Customer cust = ctx.Customers.Where(c => c.CustomerID
== "ALFKI").Single();
ctx.Customers.DeleteOnSubmit(cust);
ctx.SubmitChanges();

Does this not work? Does it error? or do nothing?

Note - the query is equivalent to below - but in this example I find
the Where(...) etc clearer...

Customer cust = (from c in ctx.Customers // your
objects
where c.CustomerID == "ALFKI" // your
guid etc
select c).Single();

Marc