c# - How to get an object with non-primitive parameters from Database.SqlQuery? -


could please advise should in question described below?

i have class "car" mapped database table (using ef code first) , it has primitive object parameters.

also have second class "user" mapped database table , class has object parameter car.

could please tell me, how can first object db, used following code ef?

dbcontext.database.sqlquery<user>("dbo.getfirstuser")

my function dbo.getfirstuser:

select userid, firstname, secondname, carid dbo.user

when try it, query returns object primitive parameters, object car null.

i thankful advice.

thanks.

using system.componentmodel.dataannotations; using system.componentmodel.dataannotations.schema;  namespace testtimerconsole {     [table("car", schema = "usr")]     class car     {         [key]         public int carid    { get; private set; }         public string name  { get; private set; }     } }  using system.componentmodel.dataannotations; using system.componentmodel.dataannotations.schema;  namespace testtimerconsole {     [table("user", schema = "usr")]     class user     {         [key]         public int userid           { get; private set; }         public string firstname     { get; private set; }         public string secondname    { get; private set; }         [foreignkey("car")]         public int carid            { get; private set; }         public car car              { get; private set; }     } }

you selecting carid. need select car object database. there several ways can this.

examples

using (var context = new dbcontext()) {     var query = u in context.users                 join c in context.car on u.carid equals c.carid                 select new user                  {                     userid = u.userid,                     firstname = u.firstname,                     lastname = u.lastname,                     car = new car()                     { carid = c.carid, name = c.name }                  } }

after selecting user using stored procedure select car

user user = dbcontext.database.sqlquery<user>("dbo.getfirstuser"); car car = dbcontext.user.firstordefault(x => x.carid == user.carid); //or create stored proc if want.

i think updated stored procedure return everything. have make sure properties map correctly though.

so change the stored procedure this:

select userid, firstname, secondname, carid, c.name [car.name] dbo.user u inner join dbo.car c on u.carid = c.carid

Comments

Post a Comment

Popular posts from this blog

PHP and MySQL WP -

i trying accomplish 2 things here code. writing php directly wp page using insert php plugin. 1) query mysql database , return results 1 column 4 columns. 2) make each result own hyperlink directs user new wp page runs new query on page. i able query show results , turn results dynamic hyperlink, cannot formatting down. right returns result 1 column. here have: [insert_php] $servername = "localhost"; $username = "login"; //edited privacy $password = "password"; //edited privacy $database = "database"; //edited privacy // create connection $conn = new mysqli($servername, $username, $password, $database); // check connection if ($conn->connect_error) { die("connection failed: " . $conn->connect_error); } echo "connected successfully"; //get results database $result = mysqli_query($conn,"select mine mines order mine"); $all_property = array(); //declare array saving property //showing proper...
Read more

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

go - golang pprof for c library code -

i have been trying profile golang application pprof, seems details of c code(linked static library) missed in output result. flame graph from frame graph can see c code time consuming reported within "runtime._externalcode", no details @ all. , sure static library compiled debug enable. so there way make pprof details(like stack trace) of 3rd party c code? or there other golang profiling tool this?
Read more