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.
