SQL Server 先行編譯執行SQLs

標籤：zz

問題描述：

MVC5項目，利用執行sql的方式擷取資料，但是在利用先行編譯執行的時候報錯了，欄位XXXwhich was not supplied.

其實就是這個參數傳了個null導致的。在傳參數之前做個判斷，如果為null就賦值為空白串即可。

650) this.width=650;" src="/img/fz.gif" alt="複製代碼" style="margin:0px;padding:0px;border:none;" />

 (=

String sql = "select a.Id,a.UserName,a.TrueName,ISNULL(b.OTM, ‘0‘) as Flag from SysUser a left join FIX_MatchingModel b on cast(a.Id as varchar) = b.OTM and b.Id = @matchingId Where a.DepId = @DepId order by b.OTM desc";
SqlParameter[] sqlParameters = { new SqlParameter { ParameterName = "matchingId", Value = matchingId }, new SqlParameter { ParameterName = "DepId", Value = depId } };
DbContexts DbContext = new DbContexts();
return DbContext.Database.SqlQuery<UserView>(sql, sqlParameters).ToList();

650) this.width=650;" src="/img/fz.gif" alt="複製代碼" style="margin:0px;padding:0px;border:none;" />

SQL Server 先行編譯執行SQLs