CODE EXAMPLE FOR CSHARP

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