我有一个问题需要在Dapper查询中返回单个对象。我有一个简单的查询,想要从返回的集合中获取第一个对象。我错过了什么?
using (SqlConnection sqlConnection = new SqlConnection(GetConnectionString()))
{
string query = @"select * from order";
sqlConnection.Open();
// Works
var orders = sqlConnection.Query<OrderModel>(query);
// Does Not Work ERROR: "does not contain a definition for 'FirstOrDefault' and
// no extension method 'FirstOrDefault'
// accepting a first argument of type 'System.Collections.Generic.IEnumerable<OrderModel>'"
var order = sqlConnection.Query<OrderModel>(query).FirstOrDefault();
}
select top 1 * ...
呢? - leppieusing System.Linq;
。 - Marc Gravell