or ISession.Delete<T>(Expression<Func<T,bool>> query)
2011/1/18 Fabio Maulo <[email protected]> > I think he need a new overload of ISession.Delete (the LINQ version of > ISession.Delete(string)). > Perahaps: > ISession.Delete(IQueriable) > > > On Tue, Jan 18, 2011 at 6:10 AM, Ayende Rahien <[email protected]> wrote: > >> We need to see the actual code that he uses. >> In general, an HqlQuery isn't translated to HqlString, it is then >> being executed. >> >> On Jan 18, 11:02 am, Mark Kharitonov <[email protected]> >> wrote: >> > Dear ladies and sirs. >> > >> > This post is related to this one on SO - >> http://stackoverflow.com/questions/1327306/does-anyone-know-how-to-tr... >> > >> > In short, how can one use linq to delete entities? >> > >> > There a responder who claims to be 95% along the way to the solution >> > using NH3, but he is missing the final step. >> > >> > BEGIN QUOTE >> > >> ___________________________________________________________________________ >> _________ >> > I had the exact same need: I needed to delete using a LINQ expression, >> > but NHibernate only supports delete using HQL or SQL. I don't like >> > this approach, since the rest of the code is completely strongly typed >> > with LINQ expression, and I then had to relate to table and property >> > names and manipulating strings. >> > >> > I am working with NHibernate 3.0 and I came 95% of the way, but I had >> > to use reflection to call some private/internal methods on the way. >> > The below gives me an HqlQuery object for the LINQ expression: >> > >> > NhQueryable<Product> queryable = (from p in session.Query<Product>() >> > where p.ProductId == 1 >> > select p) as NhQueryable<Product>; >> > if (queryable != null) >> > { >> > Expression expression = queryable.Expression; >> > NhQueryProvider provider = queryable.Provider as NhQueryProvider; >> > MethodInfo prepareQueryMethod = >> > typeof(NhQueryProvider).GetMethod("PrepareQuery", >> > BindingFlags.Instance | BindingFlags.NonPublic); >> > object[] arguments = new object[] {expression, null, null}; >> > NhLinqExpression nhLinqExpression = >> > prepareQueryMethod.Invoke(provider, arguments) as NhLinqExpression; >> > ExpressionToHqlTranslationResults translationResults = >> > nhLinqExpression.ExpressionToHqlTranslationResults; >> > HqlQuery hql = translationResults.Statement as HqlQuery; >> > >> > } >> > >> > I am stuck on that I am not able to convert the HqlQuery object to a >> > HQL string. Anyone have any input on this? Or did you solve your >> > problem in a different way? >> > >> > Anyway I think it could be a great addition to have an overload of >> > ISession.Delete, that took an IQueryable or IQuery as parameter. I am >> > a newbie to NHibernate, but it seems to me it should be a fairly >> > simple task for someone knowing NHibernate to find some already >> > existing methods and wire them up to do the job. >> > >> ___________________________________________________________________________ >> _________ >> > END QUOTE >> > >> > I was wondering if any one on this mailing list can complete the >> > missing 5%. >> > Thanks. >> >> -- >> You received this message because you are subscribed to the Google Groups >> "nhusers" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]<nhusers%[email protected]> >> . >> For more options, visit this group at >> http://groups.google.com/group/nhusers?hl=en. >> >> > > > -- > Fabio Maulo > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<nhusers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > -- You received this message because you are subscribed to the Google Groups "nhusers" 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/nhusers?hl=en.
