c# - Returning multiple related entity types from raw SQL queries in Entity Framework -

-

noodling around raw sql queries in entity framework. right in thinking given these 2 related ef classes:

public partial class campaign {     public int campaignid { get; set; }      public virtual icollection<quote> quotes { get; set; } }  public partial class quote {     public int quoteid { get; set; }     public int campaignid { get; set; }      public virtual campaign campaign { get; set; } }

the tables joined foreign key, , objects generated db first entity framework.

i can't issue raw query campaigns , related quotes? i've tried this:

string sqlquery = "select * campaign c join quote q on q.campaignid = c.campaignid"; var meh = entities.database.sqlquery<campaign>(sqlquery);

which brings campaigns without quotes. i'm guessing it's not feasible wanted check i'm not doing wrong?

i couldn't find definitive answer in documentation. , older related question fetching complex objects raw sql query in entity framework has upvotes no answers.

people have suggested duplicate of ef5 db.database.sqlquery mapping returned objects there's 1 difference: need related, nested entities rather complex type. effectively, want use sqlquery return identical result set to

entities.campaigns.include(c => c.quotes);

(if want know why it's because have more complex set of includes returning large amounts of unasked data. no-one seems able explain why happening, i'm casting round alternative approaches)

i dont think can raw sql query. trying achieve nested realtionship model ef provides model mappings raw sql query provide same flat result running sql query on database. killing entity framework relational modeling concept , want same result ef provides relational mapping mechanism


Comments

Post a Comment

Popular posts from this blog

Hatching array of circles in AutoCAD using c# -

-
i beginner in autocad plugins .i have created array of circle using following code. now, have hatch circles in array .how that??how hatch circles @ once? moreover, how can return hatch method , use hatch objects.sorry language.thanks in advance. [assembly: commandclass(typeof(beamsection.class1))] namespace beamsection { public class class1 { //class1 obj = new class1(); [commandmethod("beamatsupport")] public void addlightweightpolyline() { // current document , database document acdoc = application.documentmanager.mdiactivedocument; database accurdb = acdoc.database; promptpointresult ppr = acdoc.editor.getpoint("\nselect starting point "); var ucs = acdoc.editor.currentusercoordinatesystem; point3d startingpt = ppr.value.transformby(ucs); list<double> radius = new list<double>(); radius.add(0.5);
Read more

ios - UITEXTFIELD InputView Uipicker not working in swift -

-
hello trying pop uipickerview view programmatically when user clicks on textfield. have tried doesn't doing anything. isn't working. nothing happening when click textfield class userprofiletableviewcontroller: uitableviewcontroller,uitextfielddelegate,uipickerviewdelegate,uipickerviewdatasource { var itempicker: uipickerview! = uipickerview() @iboutlet weak var gendertxtfield: uitextfield! var gender = ["male","female"] override func viewdidload() { super.viewdidload() gendertxtfield.delegate = self itempicker!.delegate = self itempicker!.datasource = self itempicker!.backgroundcolor = uicolor.blackcolor() self.gendertxtfield.inputview = itempicker } func numberofcomponentsinpickerview(pickerview: uipickerview) -> int{ return 1 } // returns # of rows in each component.. func pickerview(pickerview: uipickerview, numberofrowsincomponent component:
Read more

Python Pig Latin Translator -

-
so have been working on @ codecademy.com while trying learn python. don't know if blind , can't see why won't work or what. here's code won't let me use. function print variable if had typed in , print "empty" if didn't type anything. print "welcome english pig latin translator!" original = raw_input("what's name?") if len(original) > 0 print original else print "empty" if len(original) > 0 else the above lines contains syntax errors. try: if len(original) > 0: else: note added colons, ( : ).
Read more