public Movie FirstOrDefault(int ID)
{
using (var conn = new SqlConnection(_ConnectionString))
{
conn.Open();
var helper = new DbHelperSql(conn);
string sql = @"
select ID, Genre, Price, ReleaseDate, Title
from Movie
where ID = @ID
";
var paramIn = new SqlParameter("@ID", ID);
var reader = helper.ExecReaderSql(sql, paramIn);
if (!reader.HasRows)
{
return(null);
}
reader.Read();
return(new Movie()
{
Id = reader.GetInt32("ID"),
Genre = reader.GetString("Genre"),
Price = reader.GetDecimal("Price"),
ReleaseDate = reader.GetDateTime("ReleaseDate"),
Title = reader.GetString("Title"),
});
}
}