How to write custom sql query using entity framework

Question

Nikhil Sangani · Answer

Hi Vamsi davuluri I hope this will help you. using (var ctx = new SchoolDBEntities()) { var studentList = ctx.Students.SqlQuery(Select * from Student).ToList (); }

Bikesh Srivastava · Answer

If you want write sql query inside entity framework that is called inline query... var data=ctx.db_name.SqlQuery( Select * from TBL_name);

Vinay Singh · Answer

Hi check the code using (var ctx= new SchoolDBEntities()) { var studentName=ctx.Students.SqlQuery(Select studentidstudentname from Student where studentname= 'NewStudent1' ).ToList(); } For detail have a look of the link http://www.entityframeworktutorial.net/EntityFramework4.3/raw-sql-query-in-entity-framework.aspx

vamsi davuluri · Answer

Thanks