One way i know is to create a subclass of AbstractCriterion, override ToSqlString and implement that how you want. We have used it to support the OVERLAPS operator in Postgresql. However your question is about LINQ to SQL not criteria, but still a option.
Op vrijdag 30 november 2018 11:37:35 UTC+1 schreef Gökhan Abatay: > > I am using Oracle database and it' supported. > > If NH can translate linq or hql below this format or support dialect level > differences about multiple in clause that would be awesome. > > SELECT * FROM TABLE WHERE ((COLUMN_1 = x and COLUMN_2 = Y) or (COLUMN_1 = > Z and COLUMN_2 = k)) > > > On Friday, November 30, 2018 at 12:32:36 PM UTC+3, Ricardo Peres wrote: >> >> This is not supported in any SQL-compliant server that I know. See, for >> example, for SQL Server, this SO answer: >> https://stackoverflow.com/questions/35194028/in-clause-in-sql-server-with-multiple-columns/47301855 >> . >> Where do you want to run it? >> >> RP >> >> On Thursday, November 29, 2018 at 8:45:50 PM UTC, Gökhan Abatay wrote: >>> >>> Hi, >>> How can I write linq to sql in criteria with multiple 2 dimensional >>> variables. >>> >>> As output sql need to be; >>> >>> SELECT * FROM TABLE WHERE (COLUMN_1,COLUMN_2) IN ((x,Y),(Z,k),(M,L)) >>> >> -- You received this message because you are subscribed to the Google Groups "nhusers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/nhusers. For more options, visit https://groups.google.com/d/optout.
