How to write custom sql query using entity framework

Question

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 studentid,studentname  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

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 (); }