MVC finding row in database not using primary key

Question

Assuming I have the following class:

public class Item

{
     [Key]
     public int itemID {get; set;}
     public int typeID {get; set;}
}

I understand that finding a record in database usually is by the primary key, e.g.

Item item = db.Item.Find(id);

How do I find the record by another column? i.e. find all the records where typeID = 1?

Note that this has almost nothing to do with MVC itself - it's purely a function of your model and data access layer, which is generally agnostic toward the hosting application. — GalacticCowboy
– GalacticCowboy, Commented Feb 25, 2013 at 17:21

Sergey Berezovskiy · Accepted Answer · 2013-02-25 17:29:35Z

6

Item item = db.Items.FirstOrDefault(i => i.typeID == 1);

Keep in mind, that if you are not using primary key, then there could be more than one item matching your query. You can use FirstOrDefault as in sample above to get first (if any) item which matches query.

To get all items with specified type id, use Where:

var items = db.Items.Where(i => i.typeID == 1);

edited Feb 25, 2013 at 17:29

answered Feb 25, 2013 at 17:19

Sergey Berezovskiy

237k44 gold badges441 silver badges468 bronze badges

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

Collectives™ on Stack Overflow

MVC finding row in database not using primary key

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related