public NavigationInfo Read(NavigationClassType classType, int classId)
{
using (var conn = new SqlConnection(connectString))
{
string sql = "select * from Navigation where classType=@classType and classId=@classId";
var data = conn.Query <NavigationInfo>(sql, new { classType = (int)classType, classId = classId }).SingleOrDefault();
return(data ?? new NavigationInfo());
}
}
public static NavigationInfo Read(NavigationClassType classType, int classId)
{
return(dal.Read(classType, classId));
}
