Entity Framework return no value

Question

Trying to select value from a empty records:

 var id = (from transactions in testTransactions.Transactions
                                      orderby transactions.TransID descending select transactions.TransID).First();

How can I give a default value then the table is empty.

Thnak you.

COLD TOLD · Accepted Answer · 2012-07-31 06:58:38Z

1

You can try this using first or default if the item is not there at all it would give null

    var id = (from transactions in testTransactions.Transactions
                                          orderby transactions.TransID descending select transactions.TransID).FirstOrDefault();
if(id!=null)
{


}

edited Jul 31, 2012 at 6:58

answered Jul 31, 2012 at 6:53

COLD TOLD

13.6k3 gold badges37 silver badges53 bronze badges

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

1 Comment

COLD TOLD Over a year ago

@Kelvin Fixx you have to check first if the value is null like above

Std_Net · Accepted Answer · 2012-07-31 08:03:43Z

0

If you have error before line IF than, maybe you must check you class testTransaction and add to all filed which can be null something like this

public string? MyVal{get;set;}

But if you use EF designer they must create all types automatically and you must change something else.

answered Jul 31, 2012 at 8:03

Std_Net

1,0963 gold badges12 silver badges26 bronze badges

Collectives™ on Stack Overflow

Entity Framework return no value

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related