public Dictionary <string, object>[] Rows()
{
return(DbInfo.Cmd(StrCmd, TypeCmd, (cmd, conn) =>
{
foreach (var p in _allParams)
{
cmd.Parameters.Add(p);
}
conn.Open();
return cmd.ExecuteReader().RowsToDict();
}));
}
public int NonQuery()
{
return(DbInfo.Cmd(StrCmd, TypeCmd, (cmd, conn) =>
{
foreach (var p in _allParams)
{
cmd.Parameters.Add(p);
}
conn.Open();
return cmd.ExecuteNonQuery();
}));
}
public object Scalar()
{
return(DbInfo.Cmd(StrCmd, TypeCmd, (cmd, conn) =>
{
foreach (var p in _allParams)
{
cmd.Parameters.Add(p);
}
conn.Open();
return cmd.ExecuteScalar();
}));
}
public DataSet Ds()
{
return(DbInfo.Cmd(StrCmd, TypeCmd, (cmd, conn) =>
{
foreach (var p in _allParams)
{
cmd.Parameters.Add(p);
}
var adp = new SqlDataAdapter(cmd);
var ds = new DataSet();
conn.Open();
adp.Fill(ds);
return ds;
}));
}
