entity framework with query C# code example

Example 1: entities query in

int[] ids = { 1, 2, 3, 4, 5};

var query = from item in db.myTable
            where ids.Contains(item.ID)
            select item;

Example 2: entity framework with query c#

using (var ctx = new SchoolDBEntities())
{
    var studentName = ctx.Students.SqlQuery("Select studentid, studentname, standardId from Student where studentname='Bill'").FirstOrDefault<Student>();
} 
//Reference Link
//https://www.entityframeworktutorial.net/Querying-with-EDM.aspx

Example 3: entity framework with query C#

using (var ctx = new SchoolDBEntities())
{
    var studentName = ctx.Students.SqlQuery("Select studentid, studentname, standardId from Student where studentname='Bill'").FirstOrDefault<Student>();
}    
//https://www.entityframeworktutorial.net/Querying-with-EDM.aspx
//https://www.entityframeworktutorial.net/EntityFramework4.3/raw-sql-query-in-entity-framework.aspx