ExecuteStoreQuery将参数传递给SQL语句

本文关键字：SQL 语句 参数传递 ExecuteStoreQuery | 更新日期: 2023-09-27 18:15:05

有人可以帮助传递一个参数对象到我的ExecuteStoreQuery。我执行这个从我的实体数据库，然后创建我的过程上飞行是可能的，是我的SQL正确。我需要传递一个Id参数值到我的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);

ExecuteStoreQuery将参数传递给SQL语句

根据MSDN文档，您的语句应该读起来更像:

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});
相关文章：