public Model.Directory.Directory FindById(int id) { using (var conn = Database.OpenRegisterDatabase()) { string sql = DirectorySql.FindById(id); return(conn.Query <Model.Directory.Directory>(sql).FirstOrDefault()); } }
public IEnumerable <Model.Directory.Directory> Select() { using (var conn = Database.OpenRegisterDatabase()) { string sql = DirectorySql.Select(); return(conn.Query <Model.Directory.Directory>(sql)); } }