private static void RunSQLite()
{
using (var dal = new DBWrapper("DBSQLite"))
{
try
{
var user = new User
{
FirstName = "First",
LastName = "Last",
Dob = DateTime.Now.AddDays(-3000),
IsActive = true
};
using (var reader = dal.ExecuteDataReaderSQL("select * from users"))
{
while (reader.Read())
{
Console.WriteLine("loop users " + reader["FirstName"]);
}
}
int count = dal.GetScalarValue <int>("select count(*) from users", CommandType.Text);
Console.WriteLine("count " + count.ToString());
}
catch (Exception ex)
{
throw new Exception("error " + ex.Message);
}
}
}