Problem Description:
The MVC5 project, which obtains the data by executing SQL, but has an error when using precompiled execution, the field Xxxwhich is not supplied.
In fact, this parameter is passed a null result. Make a decision before passing the parameter, and if NULL, assign the value to an empty string.
if (stringstring. Empty;}
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 ();
SQL Server Precompiled Execution Sqls