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.
650) this.width=650; "src="/img/fz.gif "alt=" Copy Code "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=" Copy Code "style=" Margin:0px;padding:0px;border:none; "/>
SQL Server Precompiled Execution Sqls