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