c# - dynamic number of where clause conditions in linq to sql -

-

I am trying to find the data table for all the entries that have a list of words. There may be a variable number of words in the list. Here's my code: 

  string [] word = initial string (''); Foreign currency (word of the word string) {list & lt; Mrconso_SnoMed2014 & gt; Curmatches = (One of Master DB for MrConso_SnoMed2014, where a.STR.ToLower () contains it (word toLower (). Trim ()) Select one) .list (); Matches.AddRange (curMatches); }

This code is taking too long to execute. All database calls are taking time. I would like to use some dynamic query that has a variable number where the section is something like this: 

  list & lt; Mrconso_SnoMed2014 & gt; Curmentches = (One of Master DB in Mrconso_noMed2014 where a.STR.ToLower () contains it (word [0] .over (). Trim ()) or a.STR.ToLower (). In it (the word [1]. (.) Trim ()) ... Select a) .Olist (); You can use the interface from LINQ, something looks like:     
 
  list1 Select (s = & gt; s.STR.ToLower). Exclude (list2.Select (s = & gt; s.ToLower). Trim ()))

Comments

Post a Comment

Popular posts from this blog

HTML/CSS - Automatically set height width from background image? -

-
Long time ... I do not think it's possible, but I'm shocked before! I tag anchor tags, all of which are background images, all 300px wide but their height is all the difference, is it really set to do without typing altitude? Is it to set the dimensions of BG URL? Thank you! I do not think people understand - my mistake is to hurry the question. Here is the code as an example: # ago -1 {width: 300px; Height: 410px; Background: url ('/ image-1.jpg');} # East -2 {width: 300px; Height: 420px; Background: url ('/ image-2.jpg');} # Pre-3 {width: 300px; Height: 430px; Background: url ('/ image-3.jpg');} # Pre-4 {width: 300px; Height: 440px; Background: url ('/ image-3.jpg');} & lt; A href = "#" id = "ex-1" & gt; & Lt; / A & gt; & Lt; A href = "#" id = "ex-2" & gt; & Lt; / A & gt; & Lt; A href = "#" id = "pre-3" & gt; & Lt; / A & gt...
Read more

php - Mysql Show Process - Sleep Commands and what to do -

-
I am thinking that there is something that I can do better so that my process list should start with the command with MySQL Be clear Currently I am looking for a lot: 17325 user_a localhost db_1 sleep 1132 NULL 17464 user_a localhost db_1 sleep 1124 NULL 17983 user_a localhost db_1 sleep 1078 null 18113 user_a localhost db_1 sleep 1068 NULL 18207 user_a localhost db_1 sleep 1060 NULL 18231 user_a localhost db_1 sleep 1058 NULL 18353 user_a localhost db_1 sleep 1047 NULL 18447 user_a localhost db_1 sleep 1040 null 18489 user_a localhost db_1 sleep 1036 NULL 23408 user_a localhost db_1 sleep 637 NULL Something in my phpscript is that I want to clean it Can i The script looks like: Select the ID from $ q = 'db_1 where fkId = 2'; $ Ar = mysql_query ($ q); ($ Line = mysql_fetch_array ($ qr)) {echo ($ row ['id'];} Thanks in advance! I'm guessing that when you have 10 threads, you're constantly using the connectio...
Read more

list Class in C++ -

-
I am working on a program that is considered to be reading the content of a file in the list of links "hypercard stack "(I have listed special). I know that there is a list in the C ++ standard library, but since I've never worked with the standard library before, I do not know how to make it work with this particular problem for. Any code I have received here has been successful in collecting bits of online bits and online tutorials together. My .h file: // program6.h #include & lt; Iostream & gt; # Include & lt; Fstream & gt; #include & lt; String & gt; # Include & lt; List & gt; using namespace std; Square node {public: node (); Node (four code, integer number, string data); Node (node ​​and node); ~ Node (); Bool readFile (); Zero set next (node ​​* next); Zero print (); Private: four codes; Int Num; String data; Node * next; }; My implementation file: // program6.cpp #include "program6.h" #include & lt;...
Read more