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)); }