public void SqlQueryTest()
{
using (var dbContext = new AdventureWorks2014DbContext())
{
string _sql = @"SELECT [AddressID] as ID
,[AddressLine1]
,[AddressLine2]
,[City]
,[StateProvinceID]
,[PostalCode]
,[rowguid]
,[ModifiedDate] as CreateTime
FROM[Person].[Address]
where AddressID = @AddressID";
DbParameter _paramter = new SqlParameter("@AddressID", 32529);
Address _actual = dbContext.SqlQuery <Address>(_sql, _paramter).FirstOrDefault();
Assert.IsNotNull(_actual);
}
}
