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