c# - Join 2 tables that has different ID records in entity framework -


so happen have 2 tables this:

id     time     loc               01     10:00                               02     8:00      b                   03     8:00      c       04     8:00      b

and 

id     time     loc     netval     indivalue      05     10:00           4          3            06     8:00      b       7          5            07     8:00      c       1          2

how join them have like:

id     time     loc    netval     indivalue   01     10:00                               02     8:00      b                   03     8:00      c       04     8:00      b      05     10:00           4          3            06     8:00      b       7          5            07     8:00      c       1          2

i using entity framework 5.0 work oracle 11g... please guys

edit: here have:

var last = qu.concat<object>(sm_list);

give me error: system.argumentexception: dbunionallexpression requires arguments compatible collection resulttypes

note qu , sm_list not same type nor implement same interface.

"note qu , sm_list not same type nor implement same interface."

and that's error message complains of: 

dbunionallexpression requires arguments compatible collection resulttypes

you need make 2 result sets have same projection before can concatenate them. can either adding dummy elements first collection (and populating them null or empty strings or whatever) or else excluding columns second collection.


Comments

Post a Comment

Popular posts from this blog

Python Kivy ListView: How to delete selected ListItemButton? -

Image
i'm trying learn kivy building simple todo-list app suggested dusty phillips, author of book "creating apps in kivy". this code far: from kivy.app import app kivy.uix.boxlayout import boxlayout kivy.properties import objectproperty kivy.uix.listview import listitembutton class taskbutton(listitembutton): pass class todoroot(boxlayout): task_input = objectproperty() task_list = objectproperty() def add_task(self): self.task_list.adapter.data.extend([self.task_input.text]) self.task_list._trigger_reset_populate() def del_task(self): pass class todoapp(app): def build(self): return todoroot() if __name__ == '__main__': todoapp().run() and kv file: #: import main todo #: import listadapter kivy.adapters.listadapter.listadapter #: import listitembutton kivy.uix.listview.listitembutton todoroot: <todoroot>: orientation: "vertical" task_input: task_input_view t...
Read more

asp.net mvc 4 - A specified Include path is not valid. The EntityType '' does not declare a navigation property with the name '' -

i wonder if help. above error when call .include() . breaks when include tblmemberships . this.dbcontext.configuration.lazyloadingenabled = false; list<tblcustomerinfo> customers = this.dbcontext.tblcustomerinfoes.include("tblusers").include("tblmemberships").tolist(); the reason because navigation property between tblcustomerinfo , tblmemberships not exist. tblusers link between other 2 tables. customer -- 1:* -- user -- 1:* -- membership (sorry, can't include image reputataion < 10). my questions are: what need in order have tblmemberships included? is recommended way of retrieve data or should break 2 queries? or design totally rubbish? i using ef5, asp .net mvc 4 kindly advise. thank you. when write code this: db.parenttable .include("childtable") .include("childofchildtable"); you saying include entries childtable keyed parenttable , include entries childofchildtable keyed paren...
Read more