c# - 在 .NET Core 3.1 和 EF Core 中执行存储过程

Question

这是我的代码。对于FromSqlInterpolated，它可以正常运行但存储过程不运行imo。对于ExecuteSqlCommand，当它运行时，它有语法错误@p0

        var a = "abc";
        var b = 10;
        var result = _dataContext.FileFolders.FromSqlInterpolated($"EXECUTE dbo.AddFileFolderStructure {10} {a} {a}");

       // _dataContext.Database
           .ExecuteSqlCommand("dbo.AddFileFolderStructure @p0 @p1 @p2", b, a, a);

        _dataContext.SaveChanges();

我也在下面尝试过

        var id = new SqlParameter("id", 10);
        var folderName = new SqlParameter("folderName", "1");
        var folderType = new SqlParameter("folderType", "5");
        var result = _dataContext.FileFolders.FromSqlRaw($"EXECUTE dbo.AddFileFolderStructure {id} {folderName} {folderType}");

        _dataContext.SaveChanges();

标签： c#entity-framework-core