entity framework - How to convert EntityFramework generated SQL query to simple SQL Query -


i new in linq , in existing project linq has been used need write stored procedure 1 of linq query. have generated entityframework generated sql query below want write proper sql query in stored procedure.

select      [unionall1].[id] [c1],      [unionall1].[id1] [c2],      [unionall1].[name] [c3],      [unionall1].[ydstopin] [c4],      [unionall1].[windspeed] [c5],      [unionall1].[elevation] [c6],      [unionall1].[winddirection] [c7],      [unionall1].[startcoordinate] [c8],      [unionall1].[pincoordinate] [c9],      [unionall1].[targetcoordinate] [c10],      [unionall1].[linetype] [c11],      [unionall1].[published] [c12],      [unionall1].[unpublished] [c13],      [unionall1].[deleted] [c14],      [unionall1].[book_id] [c15],      [unionall1].[imagefile_id] [c16],      [unionall1].[situationcategory_id] [c17],      [unionall1].[c1] [c18],      [unionall1].[id2] [c19],      [unionall1].[situationid] [c20],      [unionall1].[handicapid] [c21],      [unionall1].[c2] [c22],      [unionall1].[c3] [c23],      [unionall1].[c4] [c24]      (select          case when ([extent2].[id] null) cast(null int) else 1 end [c1],          [extent1].[id] [id],          [extent1].[id] [id1],          [extent1].[name] [name],          [extent1].[ydstopin] [ydstopin],          [extent1].[windspeed] [windspeed],          [extent1].[elevation] [elevation],          [extent1].[winddirection] [winddirection],          [extent1].[startcoordinate] [startcoordinate],          [extent1].[pincoordinate] [pincoordinate],          [extent1].[targetcoordinate] [targetcoordinate],          [extent1].[linetype] [linetype],          [extent1].[published] [published],          [extent1].[unpublished] [unpublished],          [extent1].[deleted] [deleted],          [extent1].[book_id] [book_id],          [extent1].[imagefile_id] [imagefile_id],          [extent1].[situationcategory_id] [situationcategory_id],          [extent2].[id] [id2],          [extent2].[situationid] [situationid],          [extent2].[handicapid] [handicapid],          cast(null int) [c2],          cast(null int) [c3],          cast(null int) [c4]          [dbo].[situations] [extent1]         left outer join [dbo].[situationhandicaps] [extent2] on [extent1].[id] = [extent2].[situationid]         (0 = [extent1].[deleted]) , (1 = [extent1].[published]) , ([extent1].[situationcategory_id] = 1) , (( not exists (select              1 [c1]             ( select                  36 [c1]                  ( select 1 x ) [singlerowtable1]             )  [project1]             ( not exists (select                  1 [c1]                 [dbo].[situationattributes] [extent3]                 ([extent1].[id] = [extent3].[situationid]) , ([project1].[c1] = [extent3].[attributesid])             )) or (case when ( exists (select                  1 [c1]                 [dbo].[situationattributes] [extent4]                 ([extent1].[id] = [extent4].[situationid]) , ([project1].[c1] = [extent4].[attributesid])             )) cast(1 bit) else cast(0 bit) end null)         )) or ( exists (select              1 [c1]             ( select                  36 [c1]                  ( select 1 x ) [singlerowtable2]             )  [project5]              exists (select                  1 [c1]                 [dbo].[situationattributes] [extent5]                 ([extent1].[id] = [extent5].[situationid]) , ([project5].[c1] = [extent5].[attributesid])             )         ))) , (( not exists (select              1 [c1]             ( select                  1 [c1]                  ( select 1 x ) [singlerowtable3]             )  [project8]             ( not exists (select                  1 [c1]                 [dbo].[situationhandicaps] [extent6]                 ([extent1].[id] = [extent6].[situationid]) , ([project8].[c1] = [extent6].[handicapid])             )) or (case when ( exists (select                  1 [c1]                 [dbo].[situationhandicaps] [extent7]                 ([extent1].[id] = [extent7].[situationid]) , ([project8].[c1] = [extent7].[handicapid])             )) cast(1 bit) else cast(0 bit) end null)         )) or ( exists (select              1 [c1]             ( select                  1 [c1]                  ( select 1 x ) [singlerowtable4]             )  [project12]              exists (select                  1 [c1]                 [dbo].[situationhandicaps] [extent8]                 ([extent1].[id] = [extent8].[situationid]) , ([project12].[c1] = [extent8].[handicapid])             )         )))     union         select          2 [c1],          [extent9].[id] [id],          [extent9].[id] [id1],          [extent9].[name] [name],          [extent9].[ydstopin] [ydstopin],          [extent9].[windspeed] [windspeed],          [extent9].[elevation] [elevation],          [extent9].[winddirection] [winddirection],          [extent9].[startcoordinate] [startcoordinate],          [extent9].[pincoordinate] [pincoordinate],          [extent9].[targetcoordinate] [targetcoordinate],          [extent9].[linetype] [linetype],          [extent9].[published] [published],          [extent9].[unpublished] [unpublished],          [extent9].[deleted] [deleted],          [extent9].[book_id] [book_id],          [extent9].[imagefile_id] [imagefile_id],          [extent9].[situationcategory_id] [situationcategory_id],          cast(null int) [c2],          cast(null int) [c3],          cast(null int) [c4],          [extent10].[id] [id2],          [extent10].[situationid] [situationid],          [extent10].[attributesid] [attributesid]          [dbo].[situations] [extent9]         inner join [dbo].[situationattributes] [extent10] on [extent9].[id] = [extent10].[situationid]         (0 = [extent9].[deleted]) , (1 = [extent9].[published]) , ([extent9].[situationcategory_id] = 1) , (( not exists (select              1 [c1]             ( select                  36 [c1]                  ( select 1 x ) [singlerowtable5]             )  [project16]             ( not exists (select                  1 [c1]                 [dbo].[situationattributes] [extent11]                 ([extent9].[id] = [extent11].[situationid]) , ([project16].[c1] = [extent11].[attributesid])             )) or (case when ( exists (select                  1 [c1]                 [dbo].[situationattributes] [extent12]                 ([extent9].[id] = [extent12].[situationid]) , ([project16].[c1] = [extent12].[attributesid])             )) cast(1 bit) else cast(0 bit) end null)         )) or ( exists (select              1 [c1]             ( select                  36 [c1]                  ( select 1 x ) [singlerowtable6]             )  [project20]              exists (select                  1 [c1]                 [dbo].[situationattributes] [extent13]                 ([extent9].[id] = [extent13].[situationid]) , ([project20].[c1] = [extent13].[attributesid])             )         ))) , (( not exists (select              1 [c1]             ( select                  1 [c1]                  ( select 1 x ) [singlerowtable7]             )  [project23]             ( not exists (select                  1 [c1]                 [dbo].[situationhandicaps] [extent14]                 ([extent9].[id] = [extent14].[situationid]) , ([project23].[c1] = [extent14].[handicapid])             )) or (case when ( exists (select                  1 [c1]                 [dbo].[situationhandicaps] [extent15]                 ([extent9].[id] = [extent15].[situationid]) , ([project23].[c1] = [extent15].[handicapid])             )) cast(1 bit) else cast(0 bit) end null)         )) or ( exists (select              1 [c1]             ( select                  1 [c1]                  ( select 1 x ) [singlerowtable8]             )  [project27]              exists (select                  1 [c1]                 [dbo].[situationhandicaps] [extent16]                 ([extent9].[id] = [extent16].[situationid]) , ([project27].[c1] = [extent16].[handicapid])             )         )))) [unionall1]     order [unionall1].[id1] asc, [unionall1].[c1] asc

please answer how convert above entityframework generated sql query code sql query


Comments

Post a Comment

Popular posts from this blog

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

i'm implementing inapp billing in android app. works well, however, i'm trying decouple broadcast receiver activity manifest. suggestion in android's trivialdrive sample: // important: dynamically register broadcast messages updated purchases. // register receiver here instead of <receiver> in manifest // because call getpurchases() @ startup, therefore can ignore // broadcasts sent while app isn't running. // note: registering listener in activity bad idea, done here // because sample. regardless, receiver must registered after // iabhelper setup, before first call getpurchases(). currently there's class extends broadcastreceiver : public class iabbroadcastreceiver extends broadcastreceiver { /** * intent action receiver should filter for. */ public static final string action = "com.android.vending.billing.purchases_updated"; private final iabbroadcastlistener mlistener; public iabbroadcastreceiver(iabbroadcastlistener listener) { m...
Read more

python Tkinter Capturing keyboard events save as one single string -

is possible store keyboard events 1 string? code below stores 1 char , prints it. card reader or bar code reader, contains collection of character/ string not 1 character @ time. goal save char pressed text variable. from tkinter import * root = tk() def key(event): text= event.char text+= event.char print ("pressed", text) def callback(event): frame.focus_set() print ("clicked at", event.x, event.y) frame = frame(root, width=100, height=100) frame.bind("<key>", key) frame.bind("<button-1>", callback) frame.pack() root.mainloop() currently, creating text variable , everytime key() function gets called, , text stores last character typed. you can define text module level variable , , use module level text inside key function - text = '' def key(event): global text text+= event.char print("pressed", text)
Read more

sql server - Why does Linq-to-SQL add unnecessary COUNT()? -

here tables: create table customer ( cid int primary key, name varchar(32) ) create table ord ( oid int primary key, cid int foreign key references customer, address varchar(20) ) here's linq-to-sql statement: var aaa = c in db.customer select new { c, o = c.ord.tolist() }; and here's inexplicable query generated linq-to-sql: select [t0].[cid] [cid], [t0].[name] [name], [t1].[oid] [oid], [t1].[cid] [cid2], [t1].[address] [address], (select count(*) [dbo].[ord] [t2] [t2].[cid] = [t0].[cid]) [value] [dbo].[customer] [t0] left outer join [dbo].[ord] [t1] on [t1].[cid] = [t0].[cid] order [t0].[cid], [t1].[oid] i want understand how rid of count(*) part. it's entirely uncalled for! linq needs count(*) in order determine number of entries returned o = c.ord.tolist() .
Read more