public IEnumerable <Music> AddList(string mids) { string sql = "select * from Music where Mid in (" + mids + ")"; var result = db.ExecuteQuery <Music>(sql); return(result); }
public static IEnumerable<Singer> SearchBySname(string name) { TianLaiDBDataContext db = new TianLaiDBDataContext(); string sql="select * from Singer where Sname like '%"+name+"%'"; var result = db.ExecuteQuery<Singer>(sql); return result; }
public static IEnumerable<Album> SearchByAlbum(string name) { TianLaiDBDataContext db = new TianLaiDBDataContext(); string sql = "select * from Album where Aname like '%" + name + "%'"; var result = db.ExecuteQuery<Album>(sql); return result; }
public static IEnumerable <Album> SearchByAlbum(string name) { TianLaiDBDataContext db = new TianLaiDBDataContext(); string sql = "select * from Album where Aname like '%" + name + "%'"; var result = db.ExecuteQuery <Album>(sql); return(result); }
public static IEnumerable <Music> SearchByMname(string name) { TianLaiDBDataContext db = new TianLaiDBDataContext(); string sql = "select * from Music where Mname like '%" + name + "%'"; var result = db.ExecuteQuery <Music>(sql); return(result); }