c# - Only parameterless constructors and initializers are supported in LINQ to Entities. (ASP.NET Web API) -


i have webapi controller generate xml table data

here code

  public class xmlcontroller : apicontroller {     private trackingappentities db = new trackingappentities();     [httpget]     public httpresponsemessage index()     {         var xdoc = new xdocument(             new xelement("data",                 db.timetables.select(w =>                     new xelement("worker",                         new xattribute("id", w.inn),                         new xelement("start", w.startday),                         new xelement("pause", w.startpause),                         new xelement("continue", w.endpause),                         new xelement("end", w.endday)                     )                 )             )         );          return new httpresponsemessage() { content = new stringcontent(xdoc.tostring(), encoding.utf8, "application/xml") };     } }

here timetable class

 public partial class timetable {     public int id { get; set; }     public string company { get; set; }     public string inn { get; set; }     public string startday { get; set; }     public string startpause { get; set; }     public string endday { get; set; }     public string endpause { get; set; } }

but when send request, have response

only parameterless constructors , initializers supported in linq entities.

how can fix this?

linq works inspecting code of function calls, rather result.

in case, solution call asenumerable tell linq populate each record sql, before calling constructor.

var timetables = db.timetables     /*      * select optional; improve performance table many       * properties, have little-to-no relevant impacts if you're      * using them all. similar select * versus selecting individual      * columns.      */     .select(c => new {         c.inn,         c.startday,         c.startpause,         c.endpause,         c.endday     })     .asenumerable(); // or ...await tolistasync();  var xdoc = new xdocument(         new xelement("data",             timetables.select(w =>                 new xelement("worker",                     new xattribute("id", w.inn),                     new xelement("start", w.startday),                     new xelement("pause", w.startpause),                     new xelement("continue", w.endpause),                     new xelement("end", w.endday)                 )             )         )     );

otherwise, can imagine linq trying send logic generating xelement directly sql. since sql wouldn't understand logic involved in process, linq throws.

in example, select call builds anonymous type. because it's guaranteed have no additional logic performed in constructor, linq able select values, , populate them c#-side.


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