常见的ORM框架有EF,Dapper,NHibernate
参考: http://shuai7boy.iteye.com/blog/2357339
http://www.cnblogs.com/Sinte-Beuve/p/4231053.html
http://www.cnblogs.com/shuai7boy/p/7269928.html
DEMO:
using System; using System.Collections.Generic; using System.Data; using System.Data.SqlClient; using System.Linq; using System.Reflection; using System.Text;namespace ConsoleApplication1 {class Program{ static void Main(string[] args){IEnumerable<test> test = Selecttests();Console.ReadKey();}private static readonly string sqlconnection = "server=.;database=Inferno;integrated security=true;"; public static SqlConnection OpenConnection(){SqlConnection connection = new SqlConnection(sqlconnection);connection.Open();return connection;} public static IEnumerable<test> Selecttests(){using(IDbConnection conn=OpenConnection()){const string query = "select *from test order by name;"; return conn.Query<test>(query, null);}}}public class test{public string name{get;set;}public string age{get;set;}public string gender{get;set;}public string userName{get;set;}public string caoZuo { get; set; }}}