ExecuteStoreQuery将参数传递给SQL语句
问题描述:
有人可以帮助将参数对象传递到我的ExecuteStoreQuery
。我从我的实体数据库执行此操作,然后即时创建我的过程是可能的,并且是我的SQL正确。我需要一个Id
参数值传递到我的SQL语句ExecuteStoreQuery将参数传递给SQL语句
var node = db.ExecuteStoreQuery<Node>(@"
@Id int // not sure about this declaration for parameter
with c as (
select Id, Name, ParentId,[0] as level
from Department d
union all
select d.Id, d.Name, d.ParentId, [level] + 1
from Department d
join c on d.ParentId = c.Id)
select * from c where c.Id = @Id"
"Departments",
System.Data.Objects.MergeOption.NoTracking,
new object{ Id: department.Id} // <--parameter object not working);
答
按照MSDN documentation,您的语句需要更多的像阅读:
var node = db.ExecuteStoreQuery<Node>(@"
with c as (
select Id, Name, ParentId,[0] as level
from Department d
union all
select d.Id, d.Name, d.ParentId, [level] + 1
from Department d
join c on d.ParentId = c.Id)
select * from c where c.Id = @Id"
"Departments",
System.Data.Objects.MergeOption.NoTracking,
new SqlParameter{ ParameterName = "id", Value = department.Id});