Access to the return value from the database by linq

Question

I need to send a value to database this my code

var concerthallID = from _concert in db.tbl_Content_Context
    join _concerthall in db.tbl_Concert_ConcertHall on _concert.ContextID equals _concerthall.ContextID
    where _concert.EnContextID == concertid
    select _concerthall.ConcertHallID;

how to set ConcertHallID to a Variable?

I think i misunderstood the question do you mean you want to update the database or do you want to select the ID? — oqx
– oqx, Commented Jun 2, 2015 at 20:31

Aram · Accepted Answer · 2015-06-02 20:31:08Z

1

Your query will return an Iqueryable, so if it will return one row or you need the first one use this after your code:

var ID = concerthallID.FirstOrDefault();

answered Jun 2, 2015 at 20:31

Aram

5,7572 gold badges33 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

UpAndAdam · Accepted Answer · 2015-06-02 20:41:26Z

1

You'll need to select a single concert and select the id from it after making sure it is not null, the code should be something like this:

var concert = (from _concert in db.tbl_Content_Context
    join _concerthall in db.tbl_Concert_ConcertHall on _concert.ContextID equals _concerthall.ContextID
    where _concert.EnContextID == concertid
    select _concert).SingleOrDefault();

var concerthallID = 0;
if (concert !=null)
    concerthallID = concert.ConcertHallID;

Remember to surround this with a try catch block to make sure that the single is returning only one.

edited Jun 2, 2015 at 20:41

UpAndAdam

5,5075 gold badges33 silver badges49 bronze badges

answered Jun 2, 2015 at 20:36

oqx

2,4471 gold badge19 silver badges28 bronze badges

Collectives™ on Stack Overflow

Access to the return value from the database by linq

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related