Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Strongly Typed Updates and Deletes

Description

It was once discussed on NHibernate Development (https://groups.google.com/forum/#!searchin/nhibernate-development/strongly$20typed$20update$20linq/nhibernate-development/TukmNqPOfCc/RsYJGCNy2UgJ) the possibility to support LINQ-style deletes and updates, similar to what Entity Framework Extended (https://github.com/loresoft/EntityFramework.Extended) has for EF.
My idea is something like this:

session.Query<Product>().Where(x => x.Price > 1000).Delete();

Or:

session.Query<Product>().Delete(x => x.Price > 1000);

And:

session.Query<Product>().Where(x => x.Price > 1000).Update(x => x.Price = 500);

Environment

None

is duplicated by

Activity

Show:

DzmitryL February 1, 2016 at 1:15 PM

I hope it will be checked into NH 4. VITA ORM has such kind of queries. Lack of such things in NHibernate leads to untyped queries. On our project it leads to SQL code very often. Such queries are essential to maintenance and performance.

http://vita.codeplex.com/
```
Full LINQ support for database querying. And not only SELECTs - you can use LINQ expressions to execute INSERT, UPDATE and DELETE statements.
```

Does NH has donate button anywhere?

Ricardo Peres January 1, 2015 at 4:29 PM

Ricardo Peres June 26, 2013 at 8:57 AM

Well, I implemented a proof of concept, but it is far from optimal.
I think this would be a nice addition to the 4 branch, don't you think? However, I don't know how long it would take to implement, nor if there is someone willing to...

Alex Zaytsev June 26, 2013 at 2:34 AM

Amm..... ok. You are...

Alex Zaytsev June 26, 2013 at 2:33 AM

I thought someone already implemented this as an separated lib. Am I right?

Fixed

Details

Assignee

Reporter

Labels

Components

Fix versions

Affects versions

Priority

Who's Looking?

Open Who's Looking?

Created June 25, 2013 at 1:23 PM
Updated August 25, 2017 at 4:41 AM
Resolved August 25, 2017 at 4:41 AM
Who's Looking?