//[Test] public void SelectArtistFullWithLazyLoadingTitles() { using (var db = new MusicDB()) { var query2 = new FullSqlQueryT <Artist2>(db); var artist = query2.SelectByKey(2643); var titles = artist.Titles; } }
//[Test] public void SelectTitleFull() { using (var db = new MusicDB()) { var query2 = new FullSqlQueryT <Title>(db); var title = query2.SelectByKey(137653); var titleName = title.Name; } }
//[Test] public void SelectArtistFullWithLazyLoadingTitles() { using (var db = new MusicDB()) { var query2 = new FullSqlQueryT<Artist2>(db); var artist = query2.SelectByKey(2643); var titles = artist.Titles; } }
//[Test] public void SelectAllTitlesFull() { using (var db = new MusicDB()) { var query = new FullSqlQueryT <Title>(db); var titles1 = query.SelectAll <List <Title> >(); List <Title> titles2 = query.SelectAll(); } }
//[Test] public void SelectAllTitlesFull() { using (var db = new MusicDB()) { var query = new FullSqlQueryT<Title>(db); var titles1 = query.SelectAll<List<Title>>(); List<Title> titles2 = query.SelectAll(); } }
//[Test] public void SelectAllArtistsLazyLoading() { using (var db = new MusicDB()) { var dbCmd = db.SetCommand("SELECT ID_ARTIST FROM PITAFR01.Artist where date_creation > sysdate - 200"); dbCmd.MappingSchema = new FullMappingSchema(); var art = dbCmd.ExecuteList <Artist2>(); var titles = art[0].Titles; var query2 = new FullSqlQueryT <Artist2>(db); var artists = query2.SelectAll(); var artist2 = artists[0]; var titles2 = artist2.Titles; } }
//[Test] public void SelectAllArtistsLazyLoading() { using (var db = new MusicDB()) { DbManager dbCmd = db.SetCommand("SELECT ID_ARTIST FROM PITAFR01.Artist where date_creation > sysdate - 200"); dbCmd.MappingSchema = new FullMappingSchema(); List<Artist2> art = dbCmd.ExecuteList<Artist2>(); List<Title> titles = art[0].Titles; var query2 = new FullSqlQueryT<Artist2>(db); List<Artist2> artists = query2.SelectAll(); Artist2 artist2 = artists[0]; List<Title> titles2 = artist2.Titles; } }
//[Test] public void SelectTitleFull() { using (var db = new MusicDB()) { var query2 = new FullSqlQueryT<Title>(db); var title = query2.SelectByKey(137653); var titleName = title.Name; } }
public void SelectTitleWithArtistQueryAssociation() { using (var db = new MusicDB()) { var query = new FullSqlQuery(db); var title = (Title) query.SelectByKey(typeof (Title), 137653); Console.WriteLine(title.Name); var query2 = new FullSqlQueryT<Title>(db); var title2 = query2.SelectByKey(137653); Console.WriteLine(title2.Name); } }
public void SelectArtistWithTitlesLazyLoadingOnQueryAssociation() { using (var db = new MusicDB()) { var query2 = new FullSqlQueryT<Artist2>(db); Artist2 artist = query2.SelectByKey(2643); List<Title> titles = artist.Titles; Console.WriteLine(titles.Count); } }
public void SelectAllTitlesFullQueryAssociation() { using (var db = new MusicDB()) { var query = new FullSqlQueryT<Title>(db); List<Title> titles2 = query.SelectAll(); Assert.IsTrue(titles2.Count > 0); } }