|
0
|
1 using System.Collections.Generic;
|
|
|
2 using BLToolkit.Data;
|
|
|
3 using BLToolkit.Data.DataProvider;
|
|
|
4 using BLToolkit.DataAccess;
|
|
|
5 using BLToolkit.Mapping;
|
|
|
6 using NUnit.Framework;
|
|
|
7
|
|
|
8 namespace UnitTests.CS.JointureTests
|
|
|
9 {
|
|
|
10 //[TestFixture]
|
|
|
11 internal class AssociationTests
|
|
|
12 {
|
|
|
13 [TestFixtureSetUp]
|
|
|
14 public void Setup()
|
|
|
15 {
|
|
|
16 DataProviderBase provider = new OdpDataProvider();
|
|
|
17 DbManager.AddDataProvider(provider);
|
|
|
18 DbManager.AddConnectionString(provider.Name,
|
|
|
19 string.Format(
|
|
|
20 "data source={0};User Id={1};Password={2};Incr Pool Size=1;Max Pool Size=3; Connection Timeout=15; pooling=false",
|
|
|
21 "MUSICFR01.TEST", "scurutchet", "kisscool12"));
|
|
|
22 }
|
|
|
23
|
|
|
24 //[Test]
|
|
|
25 public void SelectAllArtistsIgnoreLazyLoading()
|
|
|
26 {
|
|
|
27 using (var db = new MusicDB())
|
|
|
28 {
|
|
|
29 var query2 = new FullSqlQuery(db, true); //loading is automatic
|
|
|
30 var artist2 = (Artist2) query2.SelectByKey(typeof (Artist2), 2643);
|
|
|
31 var titles2 = artist2.Titles;
|
|
|
32
|
|
|
33 var query = new FullSqlQuery(db); // Dont ignore lazyloading
|
|
|
34 var artist = (Artist2) query.SelectByKey(typeof (Artist2), 2643);
|
|
|
35 var titles = artist.Titles;
|
|
|
36 Assert.AreEqual(titles2.Count, titles.Count);
|
|
|
37 }
|
|
|
38 }
|
|
|
39
|
|
|
40 //[Test]
|
|
|
41 public void SelectAllArtistsLazyLoading()
|
|
|
42 {
|
|
|
43 // using (var db = new MusicDB())
|
|
|
44 // {
|
|
|
45 // var dbCmd = db.SetCommand("SELECT ID_ARTIST FROM PITAFR01.Artist where date_creation > sysdate - 200");
|
|
|
46 //
|
|
|
47 // dbCmd.MappingSchema = new FullMappingSchema();
|
|
|
48 //
|
|
|
49 // var art = dbCmd.ExecuteList<Artist2>();
|
|
|
50 // var titles = art[0].Titles;
|
|
|
51 // var query2 = new FullSqlQueryT<Artist2>(db);
|
|
|
52 // var artists = query2.SelectAll();
|
|
|
53 // var artist2 = artists[0];
|
|
|
54 // var titles2 = artist2.Titles;
|
|
|
55 // }
|
|
|
56 }
|
|
|
57
|
|
|
58 //[Test]
|
|
|
59 public void SelectAllTitlesFull()
|
|
|
60 {
|
|
|
61 using (var db = new MusicDB())
|
|
|
62 {
|
|
|
63 var query = new FullSqlQueryT<Title>(db);
|
|
|
64 var titles1 = query.SelectAll<List<Title>>();
|
|
|
65 List<Title> titles2 = query.SelectAll();
|
|
|
66 }
|
|
|
67 }
|
|
|
68
|
|
|
69 //[Test]
|
|
|
70 public void SelectAllTitlesFull2()
|
|
|
71 {
|
|
|
72 using (var db = new MusicDB())
|
|
|
73 {
|
|
|
74 var query2 = new FullSqlQuery(db);
|
|
|
75 var titles = query2.SelectAll<Title>();
|
|
|
76 var title = (Title) query2.SelectByKey(typeof (Title), 137653);
|
|
|
77 }
|
|
|
78 }
|
|
|
79
|
|
|
80 //[Test]
|
|
|
81 public void SelectArtistFullWithLazyLoadingTitles()
|
|
|
82 {
|
|
|
83 using (var db = new MusicDB())
|
|
|
84 {
|
|
|
85 var query2 = new FullSqlQueryT<Artist2>(db);
|
|
|
86 var artist = query2.SelectByKey(2643);
|
|
|
87 var titles = artist.Titles;
|
|
|
88 }
|
|
|
89 }
|
|
|
90
|
|
|
91 //[Test]
|
|
|
92 public void SelectTitleFull()
|
|
|
93 {
|
|
|
94 using (var db = new MusicDB())
|
|
|
95 {
|
|
|
96 var query2 = new FullSqlQueryT<Title>(db);
|
|
|
97 var title = query2.SelectByKey(137653);
|
|
|
98 var titleName = title.Name;
|
|
|
99 }
|
|
|
100 }
|
|
|
101 }
|
|
|
102 } |
