1  public DataTable GetUsers()
 2      {
 3         using (SqlConnection con = new SqlConnection(sqlConStr)) 
 4         {
 5             using(SqlCommand cmd = con.CreateComand()) 
 6             {  
 7                 Cmd.CommandText = "SELECT * FROM Users";  
 8                 using(SqlDataReader reader = cmd.ExecuteReader())  
 9                 {  
10                     DataTable dt=new DataTable();
11                     dt.Load(dr);
12                     return dt;
13                 } 
14             }
15         }
16     }

1  public List<UserInfo> GetUsers()
2         {
3             using (var conn = Program.OpenConnection())
4             {
5                 return conn.Query<UserInfo>("SELECT * FROM Users").ToList();
6             }
7         }

 1   private Database database = DatabaseFactory.CreateDatabase();
 2   public DataTable ConverDataReaderToDataTable(IDataReader reader)
 3         {
 4             if (null == reader)
 5             {
 6                 return null;
 7             }
 8             DataTable table = new DataTable();
 9             table.Locale = CultureInfo.InvariantCulture;
10             int fieldCount = reader.FieldCount;
11             for (int i = 0; i < fieldCount; i++)
12             {
13                 table.Columns.Add(reader.GetName(i), reader.GetFieldType(i));
14             }
15             table.BeginLoadData();
16             object[] values = new object[fieldCount];
17             while (reader.Read())
18             {
19                 reader.GetValues(values);
20                 table.LoadDataRow(values, true);
21             }
22             table.EndLoadData();
23             return table;
24         }
25         
26   public DataTable GetUsers()
27         {
28             DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM Users");
29             using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
30             {
31                return ConverDataReaderToDataTable(reader);
32             }
33         }