Complex criteria for NHibernate query: Linq or ICriteria?
HQL ICriteria Linq-to-NH and any other API are translated to SQL finally. So as MS-SQL Server and others does not support wild characters directly, you can not use wild characters in your criterias.
HQL, ICriteria, Linq-to-NH and any other API are translated to SQL finally. So as MS-SQL Server and others does not support wild characters directly, you can not use wild characters in your criterias.
1 Not as asterisks, but MSS supports LIKE comparisons using % wildcards, and the NH ICriteria model supports this directly, while Linq2NH supports converting StartsWith, EndsWith and Contains into LIKE operations with % at the start, end, or both sides as applicable. – KeithS Dec 8 '10 at 15:30 But I meant asterisks – afsharm Dec 9 '10 at 5:26.
The answer I arrived at is to use the StartsWith/EndsWith methods to get a LIKE operation, then also replace any asterisks with %. If the criteria begins with an asterisk, use EndsWith, otherwise use StartsWith. This would turn "abc*" into "abc%%", "*abc" into "%%abc", and "*abc*" into "%%abc%" which all evaluate identically to non-duplicated %% wildcarded counterparts in a LIKE clause.
The only scenario in which it would not work as specified is if entering criteria that neither begins nor ends with the wildcard; if comparing "a*c" against abc, adc, and abcde, it would evaluate to "a%c%" instead of "a%c", and would return all of these instead of excluding abcde. Close enough for my purposes.
I'm using NH2.1 with FluentNH config and Linq2NH in a basic Repository model. I am attempting to set up a query that will digest various form fields from a winform. Now, this would be just great for Linq2Objects, however it's not going to get very far in a Linq2NH query for a number of reasons (custom extension methods, Regex checking, etc).
I created a different search page that has to digest similar data, however that query is executed against a different Repository datasource which requires the query as a string (SalesForce SOQL). Since NHibernate has so many more sophisticated, compiler-checked tools available, I would prefer HQL to be my last option. Retrieving and caching the entire table's contents in order to filter the results using Linq2Objects is barely feasible (the table is about 15k records), but any option that doesn't have to do this is much preferred.
The user needs to have as many wildcards as necessary; therefore, it will be infeasible to use the StartsWith()/EndsWith()/Contains() workaround. So, the question is, how would you set this up to execute against NHibernate?
I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.
Related Questions
SQL join QUERY to Nhibernate icriteria coversion?
Selecting objects not in a collection in NHibernate with ICriteria Interface?
How do I optimize ICriteria to select in NHIbernate?
How to use Dynamic Instantiation with ICriteria in Nhibernate?
Linq To Entites error: The entity or complex type … cannot be constructed in a LINQ to Entities query?
Complex LINQ query from SQL query?