Linq to SQL: Delete an entity using Primary Key only

PimpThisBlog.com — Mon, 12 Oct 2009 01:05:32 GMT

Thank you for submitting this cool story - Trackback from PimpThisBlog.com

re: Linq to SQL: Delete an entity using Primary Key only

Reza — Sun, 10 May 2009 19:40:56 GMT

Great Post! Do you have any idea how we can do the same thing for tables with more than one primary key?

re: Linq to SQL: Delete an entity using Primary Key only

Wed, 11 Feb 2009 21:15:11 GMT

you should not do the reflection yourself.

What about

table.Context.Mapping.GetTable(typeof(TTable)).TableName

re: Linq to SQL: Delete an entity using Primary Key only

Yuri — Wed, 14 Jan 2009 17:24:20 GMT

Very nice! I've used this and it works perfectly!

Thanks!!!

re: Linq to SQL: Delete an entity using Primary Key only

amyo — Fri, 26 Dec 2008 21:10:02 GMT

This is one solution to avoid roundtrip, you can use store procedure to delete particular entity without roundtrip (If it is a big performance issue in your app).

re: Linq to SQL: Delete an entity using Primary Key only

Terry — Thu, 04 Dec 2008 03:23:50 GMT

smnbss - That code could get you into trouble if your entities IQueryable is built from joining two tables. See a more reliable way of deleting at www.aneyfamily.com/.../Batch-Updates-and-Deletes-with-LINQ-to-SQL.aspx.

re: Linq to SQL: Delete an entity using Primary Key only

smnbss — Tue, 18 Nov 2008 14:32:22 GMT

Add this to your datacontext and you'll be able to delete in a much more performant way

like:

dataContext.Delete(dataContext.Threads.Where(x=>x.ThreadId == threadId));

public int Delete<T>(IEnumerable<T> entities)

{

System.Data.Common.DbCommand command = this.GetCommand(entities.AsQueryable());

string s = this.GetCommand(entities.AsQueryable()).CommandText;

command.CommandText = "DELETE [t0]\r\n" + s.Substring(s.IndexOf("FROM"));

command.Connection.Open();

int records = command.ExecuteNonQuery();

command.Connection.Close();

return records;

}

thanks to my colleague Evaldas :)

re: Linq to SQL: Delete an entity using Primary Key only

yaip — Sat, 15 Nov 2008 18:20:51 GMT

Are we going back to writing convoluted SQL code by using LINQ? The whole idea was to get away from that.

re: Linq to SQL: Delete an entity using Primary Key only

rajesh — Mon, 10 Nov 2008 10:10:10 GMT

Good solution and its very helpfull.

re: Linq to SQL: Delete an entity using Primary Key only

Daniel Fernandes — Wed, 05 Nov 2008 08:42:34 GMT

Omar: on a different subject, I downloaded your DropThings project on CodePlex but the database file/scripts are missing.

re: Linq to SQL: Delete an entity using Primary Key only

Terry Aney — Wed, 05 Nov 2008 05:55:06 GMT

Great post. Definately a little helper I'll add to my current list of L2Q extension methods (with a bit of a variation). Anyway, you can see my post at www.aneyfamily.com/.../Batch-Updates-and-Deletes-with-LINQ-to-SQL.aspx to see how I do batch updates and deletes.

re: Linq to SQL: Delete an entity using Primary Key only

Rafi — Tue, 04 Nov 2008 21:37:26 GMT

Can you write similar function for Update?

re: Linq to SQL: Delete an entity using Primary Key only

Damien Guard — Tue, 04 Nov 2008 19:45:06 GMT

This will fail with composite keys but more worryingly is open to SQL injection in the DeleteByPK function where the key is a string.

You should be very very careful about building SQL out of strings.

[)amien

re: Linq to SQL: Delete an entity using Primary Key only

cc — Tue, 04 Nov 2008 19:38:07 GMT

Not sure I'm a fan...

re: Linq to SQL: Delete an entity using Primary Key only

Luke Foust — Tue, 04 Nov 2008 18:34:55 GMT

This is great. I have run into this problem so many times but have just dealt with it on a case by case basis. A generic solution is very slick.

re: Linq to SQL: Delete an entity using Primary Key only

Usman Masood — Sun, 02 Nov 2008 14:52:13 GMT

No! doing so will simply raise row not found or some thing similar as the data is not matched...

"Can't you just attach a constructed object to the datacontext and then call DeleteOnSubmit.

Entity ent = new Entity();

Entity.pk = 1;

datacontext.Attach(ent);

datacontext.Entity.DeleteOnSubmit(ent);"

re: Linq to SQL: Delete an entity using Primary Key only

phil hoy — Thu, 30 Oct 2008 09:42:12 GMT

Can't you just attach a constructed object to the datacontext and then call DeleteOnSubmit.

Entity ent = new Entity();

Entity.pk = 1;

datacontext.Attach(ent);

datacontext.Entity.DeleteOnSubmit(ent);

re: Linq to SQL: Delete an entity using Primary Key only

Omari — Thu, 30 Oct 2008 07:41:58 GMT

I did something similar but as extension method of Table<TEntity>. I think should be mentioned that if DataContext is not readonly then single item query can return cached entity.