using (IDbConnection conn = DbProviderFactories.GetFactory(connStr.ProviderName).CreateConnection())
{
conn.ConnectionString = connStr.ConnectionString;
var sql = "select * from EMP,DEPT where EMP.deptno=DEPT.deptno";
var list = conn.Query<Model.EMP, Model.DEPT, Model.EMP>(sql, (EMP, DEPT) => { return EMP; }, null, null, true, "DEPTNO");
if (list.Count() == 0)
{
MessageBox.Show("没有查询到数据！"); return;
}
dataGridViewDemo.DataSource = list;
}
可是我如果用Query()方法的另一个重载，DataGridView上却什么数据也不显示，设置断点list已经有值，说明已经查询到数据了，可就是绑定不成功。EMP表和DEPT表的实体我都已经建好了。list.ToList()也不行，其实list本身就已经实现了IEnumerable接口可以直接绑定的。
using (IDbConnection conn = DbProviderFactories.GetFactory(connStr.ProviderName).CreateConnection())
{
conn.ConnectionString = connStr.ConnectionString;
var list = conn.Query("select EMP.* from EMP,DEPT where EMP.deptno=DEPT.deptno");
if (list.Count() == 0)
{
MessageBox.Show("没有查询到数据！"); return;
}
dataGridViewDemo.DataSource = list;
}
