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









android - How can I execute default sms app? -






-















    I registered my receiver for receiving SMS when I receive the SMS, how do I execute the phone's default SMS app Can i do   Can I send the intention to start the default SMS app?      This can be done in a few different ways. Here's one:    Send intentions = new intent (int. Action_viez); SendIntent.putExtra ("sms_body", "The content of the SMS goes here ..."); SendIntent.setType ("vnd.android-directory / MMS-SMS"); StartActivity (sendIntent);     








Read more










jquery .css('text-decoration') doesn't work from parents -






-















    I have to get the essential CSS property of the element (the property can be inherited from her parents)   Standart Jquery .css () can do this.   I have such an HTML:     & Lt; Span id = "something" & gt; Our element & lt; / Span & gt; & Lt; Br> Some text & lt; / Div & gt; & Lt; Div id = "result" & gt; & Lt; / Div & gt;    CSS:    #some {font-weight: bold; } # Containers {text-decoration: underline; Color: RGB (0,255,0); Font-size: 32px; }    and jQuery code:    $ (function () {var decor = $ ("#some") .css ('text-decoration' ) Weight Weight = $ ("#Additional"). CSS ('font-weight'); var color = $ ("#some"). CSS ('color'); var size = $ ("#some") Css ('font-size'); var result = "   Our object's own property:  Font-weight: "+ weight +"   & gt; hereditary property: & lt; / b & gt; & lt; br & gt; ; & Lt; br ...








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