public static IEnumerable <Access_sRecords_Model> GetWhere(string where)
{
using (var conn = new OleDbConnection(connectionString))
{
using (var cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.Text;
string xxxx = TableConvention.Resolve(typeof(Access_sRecords_Model));
cmd.CommandText = "select * from " + xxxx + " where " + where;
//cmd.CommandText = "select * from " + xxxx + " where "
// .InjectFrom(new FieldsBy()
// .SetFormat("{0}=@{0}")
// .SetNullFormat("{0} is null")
// .SetGlue("and"),
// where);
//cmd.InjectFrom<SetParamsValues>(where);
conn.Open();
using (var dr = cmd.ExecuteReader())
{
while (dr.Read())
{
var o = new Access_sRecords_Model();
o.InjectFrom <ReaderInjection>(dr);
yield return(o);
}
}
}
}
}
public static int Insert(string connectionString, Access_sRecords_Model o, string s)
{
//SQLiteConnection cn = new SQLiteConnection(connectionString);
//SQLiteCommand cmd = cn.CreateCommand();
//cmd.CommandText = commandText;
//AttachParameters(cmd, commandText, paramList);
//if (cn.State == ConnectionState.Closed)
// cn.Open();
//int result = cmd.ExecuteNonQuery();
//cmd.Dispose();
//cn.Close();
using (SQLiteConnection cn = new SQLiteConnection(connectionString))
using (SQLiteCommand cmd = cn.CreateCommand())
{
cmd.CommandType = CommandType.Text;
cmd.CommandText = "INSERT INTO " + TableConvention.Resolve(o) + " (DatabaseName,"
.InjectFrom(new FieldsBy().IgnoreFields("keyid"), o) + ") values(@DatabaseName,"
.InjectFrom(new FieldsBy().IgnoreFields("keyid").SetFormat("@{0}"), o)
+ ")";
cmd.Parameters.AddWithValue("@DatabaseName", s);
cmd.InjectFrom(new SetParamsValues_SQLite().IgnoreFields("keyid"), o);
cn.Open();
return(Convert.ToInt32(cmd.ExecuteNonQuery()));
}
}
public static int Insert(Access_sRecords_Model o, string s)
{
//using (var conn = new SqlConnection(connString))
//using (var cmd = conn.CreateCommand())
//{
// cmd.CommandType = CommandType.Text;
// cmd.CommandText = "insert " + TableConvention.Resolve(o) + " ("
// .InjectFrom(new FieldsBy().IgnoreFields("keyid"), o) + ") values("
// .InjectFrom(new FieldsBy().IgnoreFields("keyid").SetFormat("@{0}"), o)
// + ") select @@identity";
// cmd.InjectFrom(new SetParamsValues().IgnoreFields("keyid"), o);
// conn.Open();
// return Convert.ToInt32(cmd.ExecuteScalar());
return(SQLiteHelper.Insert(connString, o, s));
//return SQLiteHelper.ExecuteScalar(connString, commandText, paras);
}
public virtual int Insert(Access_sRecords_Model o, string s)
{
return(SQLiteEasy.Insert(o, s));
}
