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

[=?Utf-8?B?TWljaGFlbCBOZW10c2V2?=]

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

"shapper" wrote:

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

[shapper]

On Dec 4, 3:42 am, Michael Nemtsev <[e-mail] mwrote:

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

"shapper" wrote:

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 UndefinedDataCo ntext
Dim tag As Tag = From t In database.Tags _
Where t.TagID = New Guid("5f8f46cc-709c-
dc11-8760-000e35bd65c3")
database.Tags.R emove(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.W here(c =c.CustomerID
== "ALFKI").Single ();
ctx.Customers.D eleteOnSubmit(c ust);
ctx.SubmitChang es();

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