public T ExecuteReaderOfFirst <T>(ISqlExpress sql) where T : class, new()
{
IEnumerable <T> vs = ExecuteReader <T>(sql);
if (vs != null)
{
return(vs.FirstOrDefault());
}
return(null);
}
public object ExecuteReaderOfFirstFor(ISqlExpress sql)
{
System.Collections.IEnumerable l = ExecuteReaderFor(sql);
if (l != null)
{
var g = l.GetEnumerator();
if (g != null && g.MoveNext())
{
return(g.Current);
}
}
return(null);
}
public string ExecuteScalarForString(ISqlExpress sql)
{
return((string)p_Db.CommitToDatabase(sql));
}
public V ExecuteScalar <V>(ISqlExpress sql) where V : struct
{
return((V)p_Db.CommitToDatabase(sql));
}
public System.Collections.IEnumerable ExecuteReaderFor(ISqlExpress sql)
{
return(p_Db.CommitToDatabase(sql) as System.Collections.IEnumerable);
}
public IEnumerable <T> ExecuteReader <T>(ISqlExpress sql) where T : class, new()
{
return(p_Db.CommitToDatabase(sql) as IEnumerable <T>);
}
/// <summary>
/// 将sql提交到数据库
/// </summary>
/// <param name="sql"></param>
/// <returns>返回IDataExpress.Computational返回的对象</returns>
public virtual object CommitToDatabase(ISqlExpress sql)
{
sql.CurrentDbType = DbTypeName;
sql.Command = Command;
return(sql.Computational());
}
object IDatabaseAdptor.CommitToDatabase(ISqlExpress sql)
{
return(CommitToDatabase(sql));
}
