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); } } }