Entity Framework Code First executes SQL statements, views, and stored procedures

1. Entity Framework Code First query table or view

 var  provincelist = ctx. Provinces.sqlquery ( " select TOP * from province      "  foreach  (var  province in   Provincelist) {Console.WriteLine ( "  {0}-{1}-{2}   " 

    var provincelist = ctx. Database.sqlquery<tempprovince> ("select TOP Ten provinceno,provincename from province" );     foreach (var in provincelist)    {        Console.WriteLine ("{0}-{1}", province. Provinceno, Province. provincename);    }

3. Entity Framework Code First executes stored procedure

 create PROCEDURE Getcitybyprovinceid (@ProvinceID INT) as SELECT  * from the city WHERE provinceid  = @ProvinceID 

using (varnew  Portalcontext ()) {    var citylist = ctx. Cities.sqlquery ("dbo. Getcitybyprovinceid @p0"3);     foreach (var in citylist)    {        Console.WriteLine ("{0}-{1}-{2}-{3}", City. Cityid, City. Provinceid, City. Cityno, City. CityName);}    }

Stored procedure Multiple input parameters:

var " Australia " ; var " Beach, Sun " ; var destinations = context. Database.sqlquery<destinationsummary> ("dbo. Getdestinationsummary @p0, @p1", Country, keyWords);

Entity Framework Code First executes SQL statements, views, and stored procedures