c# - Linq to sql between List and Comma separated string -

-

i have 1 list , 1 comma separated column value.

lst.add("beauty"); lst.add("services"); lst.add("others");

and column value 

beauty,services service,others beauty,others other,services other beauty, food food

now want rows contains list item.

output result is

beauty,services service,others beauty,others other,services other beauty, food

first edit

these comma separated values 1 of table's 1 column value. need check against column.

assuming can figure out how rowcollection

rowcollection.where(row => row.split(",").tolist().where(x => list.contains(x)).any()).tolist();

will evaluate true if row contains value list.


Comments

Post a Comment

Popular posts from this blog

actionscript 3 - TweenLite does not work with object -

-
i got following problem: i have object called tempscore game. this object blitted canvas renderer via copypixels method. object not display object. it's score-object (self made). score-object extends object called basicblitarrayobject. basicblitarrayobject extends eventdispatcher (therefore no display object). i tried apply several different tweenlite-plugins tempscore-object (i.e. transformaroundcenter, colormatrixfilter, etc.). nothing happens. absolutely nothing. sometimes error messages (when plugin requires display object , object not display object). far good. according greensock (maker of tweenlite) engine can tween numeric property of object. when plugin transformaroundcenter requires display object tweening have modify plugin working non-display object (tempscore). can't because it's way hard me. my game rests upon code: http://www.8bitrocket.com/book/ch11_blastermines.zip try apply tweenlite object called tempmine inside game class blastermines. ...
Read more

php - How can I edit my code to echo the data of child's element where my search term was found in, in XMLReader? -

-
i new in xmlreader, , think kind of hard find tutorials/code or advanced examples. question how can transform code have now, if search (through form) term jquery give me opportunity output value of <info></info> (and later other elements) in every <name></name> found in ? this code output names of books. <?php $reader = new xmlreader(); $reader->open("books.xml"); while ($reader->read()) { switch ($reader->nodetype) { case (xmlreader::element): if ($reader->localname == "name") { $reader->read(); echo $reader->value; break; }}} ?> the xml file <?xml version="1.0" encoding="iso-8859-1"?> <library> <book isbn="781"> <name>scjp 1.5</name> <info>sun certified java programmer book</info> </book> <bo...
Read more

c# - Global Variables vs. ASP.NET Session State -

-
this going sound rather naive, i'm developing web application spans multiple pages. of these pages instantiate same class object w/ methods accesses cms using api. currently, when user starts creating content, i'm storing variables folder id content located in session variable. my question this: can instantiate single instance of class can used across pages without having on every page? if so, each person accessing page given own version of class? assume using static variables , methods isn't way go since shared in memory. , also, where/how declared if going used globally in web application in .net c# application? i recommend making base class inherits system.page. have page code behind inherit that. then, inside base class, create property reference object. example, this: public class basepage : system.web.ui.page { public foo currentfoo { { return (foo)session["foosessionob...
Read more