c# - LINQ ; Search with culture invariant -

-


This is my problem. We've got a list of enterprises, users or anything else, and we've got it "Start" With "search type, so on our site, we did not find a text field like search fields, but we have got 27 buttons" # "," A "," B "," C ", [...] A search header with "Z"

The problem is that if we click on the 'e' button, the user can click on the query to get the value from the database, ENTREPRISES names together, "a ??", "a ??" Yes, our site is in French, any idea of ​​how to do this in LINQ

It is also important to know that we are using LLBLagen Pro. So I think it must be something that it can convert into a valid SQL query.

The effort we have made here is: 

 IList & lt; Enterprise & gt; Enterprise; Switch (searchChar) {[...] case 'E':. Enterprises select ourContext.Enterprises where ENT = "EAA © êë in ENT = any (param = & gt; ent.name [0] == Ultimate) select ENT; break; [...]}  
 Which give us some of this error for an unconvertable query relatively: type  type of 'System.Linq.Expressions.ConstantExpression' to type Unable to do 'SD .LLBLGen.Pro.LinqSupportClasses.ExpressionClasses.SetExpression'.   
 We have tried to make it basically with a simple LINQ query, without having to know if it is possible to query for DB.   
 What's strange with this question is that it is not an accident, but it's not even work! While debugging, it boosts it, but when we look at the "results" list, it seems that there is nothing in it. I mean, the list is just empty but nothing in the attempt fails !  
 Please help!   
 
 
 The real solution here is to find a searchable name for your There is an additional column in the database, so whenever you add a new company, you add a value to the searchable name column. You can change all the characters in the upper (or less if you wish) and searchable names You can add a "clean" name to the column. You can also remove the punctuation at this point because Often searches are hurting  
 It will leave (and also very quickly) with a column you will never display, but it will be very easy to search for matches in this column as the form of You will never need to worry about the accented characters in search time.   

 




  




























Comments











Post a Comment

















Popular posts from this blog









qt - switch/case statement in C++ with a QString type -






-















    I want to use switch-case in my program but the compiler generates an error. How can I use the  switch  statement with  QString ?   The compiler gives me this error:    The expression of the switch type 'QString' is invalid    My code is as follows :    boolStopWord (the word QString) {bool flag = false; Switch (word) {case "the": flag = true; break ; "On" case: flag = true; break ; Case "in": flag = true; break ; Case "your": flag = true; break ; Case "near": flag = true; break ; Case "all": flag = true; break ; Case "this": flag = true; break ; } Return flag; }        How do I use the switch statement with a Caststring ?    You can not use the  switch  statement in C ++ language with integral or enum types. You can formally enter the square type of object in the  switch  statement, but this means that the compiler will look for a user-defined conversion to convert it to an integral or enum type.    








Read more










python - sqlite3.OperationalError: near "REFERENCES": syntax error -
foreign key creating -






-















    I'm trying to create a predefined key after checking the manual and I wrote it:   Db.execute ("create table" Table 2 (id, integer primary key, somedata integer) "db.execute" (table creation table 2 does not exist (name text, maintain reference (id) ")    and found this:    sqlite 3. Operation error: near" references ": syntax error              Your second ligne is wrong    db.execute ("create table if table does not exist 2 (name text, my_id integer, foreign key (my_id) reference Maintenance (ID)) ")    as explained    








Read more










Python's equivalent for Ruby's define_method? -






-















    What is a Python equivalent for Ruby's  define_method , which is the dynamic generation of class methods will allow? (As can be seen in Wikipedia)      Functions are first-class objects in Python and assign them The properties of a class or an example can be a way of doing the same thing as a Wikipedia example:    colors = {"black": "000", "red": "F00", "green": "0f0", "yellow": "ff0", "blue": "00f", "magenta": "fff", "cyan": "0ff", "white": " FFF "} Class MyStream (ARR): Pass for Name, Code in colors.iteritems (): def _in_colour ( W code = code): return '& lt; Span style = "color:% s" & gt;% s & lt; / Span & gt; ' % (Code, self) setter (histrive, "in_" + name, _in_ color)     








Read more