C#+EF 使用SQL计算表达式
C# 全选
/// <summary>
/// C#+EF 使用SQL计算表达式
/// </summary>
/// <param name="expression">表达式,如:100>99</param>
/// <returns></returns>
public bool Eval(string expression)
{
try
{
using (var context = WorkflowDbContext.CreateDbContext(this.DbOption.ConnectionString))
{
var sql = $"IF {expression} SELECT 1 ELSE SELECT 0;";
var cmd = context.Database.Connection.CreateCommand();//创建DbCommand
cmd.CommandText = sql;
context.Database.Connection.Open();
var obj = cmd.ExecuteScalar();
return obj.ToString() == "1";
}
}
catch
{
return false;
}
}
版权声明:本文为开发框架文库发布内容,转载请附上原文出处连接
NewDoc C/S框架网