Entity Framework DbContext SqlQuery、ExecuteSqlCommand

SqlQuery會回傳結果集,ExecuteSqlCommand會回傳受影響的筆數
傳遞參數的方式有以下幾種

namespace ConsoleApplication1
{
using ConsoleApplication1.Models;
using System.Data;
using System.Data.Entity;
using System.Data.SqlClient;

class Program
{
static void Main(string[] args)
{
Database.SetInitializer(new DropCreateDatabaseAlways<DemoContext>());
using (DemoContext db = new DemoContext())
{
db.Database.Initialize(false);

int colA = 123;
string colB = “abc”;

// 使用佔位符號
db.Database.SqlQuery<TableName>(“SELECT FROM TableName WHERE ColA={0} AND ColB={1}”, colA, colB);

// 使用固定名稱的參數
db.Database.SqlQuery<TableName>(“SELECT
FROM TableName WHERE [email protected] AND [email protected]”, colA, colB);

// 使用SQL參數
db.Database.SqlQuery<TableName>(
“SELECT FROM TableName WHERE [email protected] AND [email protected]”,
new SqlParameter(“ColA”, colA),
new SqlParameter(“ColB”, colB));

// 使用SQL參數並明確指定資料形態
db.Database.SqlQuery<TableName>(
“SELECT
FROM TableName WHERE [email protected] AND [email protected]”,
new SqlParameter(“ColA”, SqlDbType.Int) { Value = colA },
new SqlParameter(“ColB”, SqlDbType.VarChar, 50) { Value = colB });
}
}
}
}