asp.net - How to convert the sql statement to linq (VB) -


the following sql statement works fine, how can convert linq (vb) ?

i had looked online tools, doesn't work...

thanks

select distinct a.sid, a.displayname,      case when b.sid not null 1 else 0 end type1,     case when c.sid not null 1 else 0 end type2,     case when d.sid not null 1 else 0 end type3 dbo.vhris_emailalert left join dbo.vhris_emailalert b on a.sid = b.sid , b.type = 4 left join dbo.vhris_emailalert c on a.sid = c.sid , c.type = 5 left join dbo.vhris_emailalert d on a.sid = d.sid , d.type = 6  a.cid=37 , (b.type=4 or c.type=5 or d.type=6)

the following linq. run linq linqpad, returns "syntax error"

(from in db.vhris_emailalerts _ group join b in db.vhris_emailalerts _       on new { a.sid, .type = 4 } _   equals new { b.sid, .type = ctype(clng(b.type),int64?) } b_join = group _ b in b_join.defaultifempty() _ group join c in db.vhris_emailalerts _       on new { a.sid, .type = 5 } _   equals new { c.sid, .type = ctype(clng(c.type),int64?) } c_join = group _ c in c_join.defaultifempty() _ group join d in db.vhris_emailalerts _       on new { a.sid, .type = 6 } _   equals new { d.sid, .type = ctype(clng(d.type),int64?) } d_join = group _ d in d_join.defaultifempty() _ _   clng(a.cid) = 37 , _   (clng(b.type) = 4 or _   clng(c.type) = 5 or _   clng(d.type) = 6) _ select  _   sid = ctype(a.sid,int32?), _   a.displayname, _   type1 = if( _   not b.sid nothing, 1, 0), _   type2 = if( _   not c.sid nothing, 1, 0), _   type3 = if( _   not d.sid nothing, 1, 0)) _ ).distinct.tolist

it's complicated convert linq. create view instead of using linq


Comments

Post a Comment

Popular posts from this blog

matlab - Deleting rows with specific rules -

i got 20*3 cell array , need delete rows contains "137", "2" , "n:t" origin data: 't' '' '' 'np(*)' '' '' [ 137] '' '' [ 2] '' '' 'are' 'and' 'np(fcc_a1#1)' '' '' '1:t' [ 1200] [0.7052] '' [1.2051e+03] [0.7076] '' 'are' 'and' 'np(fcc_a1#3)' '' '' '2:t' [ 1200] [0.0673] '' [1.2051e+03] [0.0671] '' 'are' 'and' 'np(m23c6)' '' '' '3:t' [ 1200] [0.227...
Read more

php - MySQLi multi_query results for later use -

i using mysqli multi_query work several select statemets @ time. know how handle results, able use them later in code. example: <?php //connection stuff $query = "select name, surname database1;"; $query.= "select car, year, type database2 carid='1';"; $query.= "select product, price database3;"; if ($mysqli->multi_query($query)) { if($result = $mysqli->store_result()) { while($row = $result->fetch_row()) { --> here? } } } ?> <html> <div id='persona'> <?php foreach() { --> print name + surname } ?> </div> <div id='cars'> <?php foreach() { --> print car + year + type } ?> </div> <div id='product'> <?php foreach() { --> print product + price } ?> </div> </html> one more thing, prepared statements not possible when using multiple_query, right? there no benefit in putting unrelated queries in 1 multi ...
Read more