Mercurial > pub > bltoolkit

comparison UnitTests/Linq/UserTests/LetTest2.cs @ 0:f990fcb411a9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Копия текущей версии из github
author cin
date Thu, 27 Mar 2014 21:46:09 +0400
parents
children
comparison
equal deleted inserted replaced
-1:000000000000 0:f990fcb411a9
1 //---------------------------------------------------------------------------------------------------
2 // This code was generated by BLToolkit.
3 //---------------------------------------------------------------------------------------------------
4 using System;
5 using System.Linq.Expressions;
6 /*
7 using NUnit.Framework;
8
9 namespace LightStation.API
10 {
11 public interface IStationObjectID
12 {
13 }
14 }
15
16 namespace LightStation.API
17 {
18 [System.SerializableAttribute()]
19 public class MachineIdentifier : LightStation.API.StationObject, LightStation.Utils.Validation.IValidatable
20 {
21 public LightStation.API.StationObjectID OrganizationId { get; set; }
22
23 public string Value { get; set; }
24
25 public LightStation.API.StationObjectID SymbolId { get; set; }
26 }
27 }
28
29 namespace LightStation.API
30 {
31 [System.SerializableAttribute()]
32 public struct NullableStationObjectID : ValueType, LightStation.API.IStationObjectID
33 {
34 public NullableStationObjectID(Nullable<int> value)
35 {
36 }
37
38 public Nullable<int> Value { get; set; }
39 }
40 }
41
42 namespace LightStation.API
43 {
44 [System.SerializableAttribute()]
45 public abstract class StationObject : LightStation.Utils.Validation.IValidatable
46 {
47 public LightStation.API.StationObjectID Id { get; set; }
48 }
49 }
50
51 namespace LightStation.API
52 {
53 [System.SerializableAttribute()]
54 public struct StationObjectID : ValueType, LightStation.API.IStationObjectID
55 {
56 public StationObjectID(int value)
57 {
58 }
59
60 public int Value { get; set; }
61 }
62 }
63
64 namespace LightStation.API
65 {
66 [System.SerializableAttribute()]
67 public class Symbol : LightStation.API.StationObject, LightStation.Utils.Validation.IValidatable
68 {
69 public string UniqueId { get; set; }
70
71 public string TypeName { get; set; }
72
73 public bool IsActive { get; set; }
74
75 public DateTime StartDate { get; set; }
76
77 public Nullable<DateTime> EndDate { get; set; }
78
79 public string Description { get; set; }
80
81 public string Extra { get; set; }
82
83 public LightStation.API.NullableStationObjectID DataProvenanceId { get; set; }
84
85 public LightStation.API.NullableStationObjectID CountryId { get; set; }
86
87 public LightStation.API.NullableStationObjectID CurrencyId { get; set; }
88
89 public LightStation.API.NullableStationObjectID DataProviderAccountId { get; set; }
90
91 public LightStation.API.NullableStationObjectID PrimaryExchangeId { get; set; }
92
93 public LightStation.API.NullableStationObjectID CompositeExchangeId { get; set; }
94
95 public string Name { get; set; }
96
97 public string PrimaryTicker { get; set; }
98
99 public DateTime AsOfDate { get; set; }
100 }
101 }
102
103 namespace LightStation.Storage.Relational
104 {
105 [System.Runtime.CompilerServices.CompilerGeneratedAttribute()]
106 class <>c__DisplayClass2
107 {
108 public System.Linq.IQueryable<LightStation.API.MachineIdentifier> dateIdentifiers;
109
110 public Nullable<DateTime> asOfDate;
111 }
112 }
113
114 namespace LightStation.Storage.Relational
115 {
116 public interface IHasDbId<I>
117 {
118 }
119 }
120
121 namespace LightStation.Storage.Relational
122 {
123 [BLToolkit.DataAccess.TableNameAttribute(Name = "ls_exchange")]
124 public class ls_exchange : LightStation.Storage.Relational.IHasDbId<int>
125 {
126 public int organization_id { get; set; }
127 }
128 }
129
130 namespace LightStation.Storage.Relational
131 {
132 [BLToolkit.DataAccess.TableNameAttribute(Name = "ls_symbol")]
133 public class ls_symbol : LightStation.Storage.Relational.IHasDbId<int>
134 {
135 [BLToolkit.DataAccess.PrimaryKeyAttribute((Int32)1)]
136 [BLToolkit.DataAccess.IdentityAttribute()]
137 public int id { get; set; }
138
139 public string unique_id { get; set; }
140
141 public bool is_active { get; set; }
142
143 [BLToolkit.Mapping.NullableAttribute()]
144 public string type_name { get; set; }
145
146 public DateTime start_date { get; set; }
147
148 [BLToolkit.Mapping.NullableAttribute()]
149 public Nullable<DateTime> end_date { get; set; }
150
151 [BLToolkit.Mapping.NullableAttribute()]
152 public Nullable<int> data_provenance_id { get; set; }
153
154 [BLToolkit.Mapping.NullableAttribute()]
155 public Nullable<int> country_id { get; set; }
156
157 [BLToolkit.Mapping.NullableAttribute()]
158 public Nullable<int> currency_id { get; set; }
159
160 [BLToolkit.Mapping.NullableAttribute()]
161 public Nullable<int> data_provider_account_id { get; set; }
162
163 [BLToolkit.Mapping.NullableAttribute()]
164 public Nullable<int> primary_exchange_id { get; set; }
165
166 [BLToolkit.Mapping.NullableAttribute()]
167 public Nullable<int> composite_exchange_id { get; set; }
168
169 [BLToolkit.Mapping.NullableAttribute()]
170 public string description { get; set; }
171
172 [BLToolkit.Mapping.NullableAttribute()]
173 public string extra { get; set; }
174
175 [BLToolkit.Mapping.AssociationAttribute(ThisKey = "primary_exchange_id", OtherKey = "id", CanBeNull = True)]
176 public LightStation.Storage.Relational.ls_exchange symbolexchangeprimary { get; set; }
177 }
178 }
179
180 namespace LightStation.Storage.Relational.Tests.IRelationalStorageTests
181 {
182 [System.Runtime.CompilerServices.CompilerGeneratedAttribute()]
183 class <>c__DisplayClassa5
184 {
185 public LightStation.API.Symbol symbol;
186 }
187 }
188
189 namespace LightStation.Utils.Validation
190 {
191 public interface IValidatable
192 {
193 }
194 }
195
196 namespace Data.Linq
197 {
198 [TestFixture]
199 public class UserTest : TestBase
200 {
201 [Test]
202 public void Test()
203 {
204 // Table(ls_symbol).Select(symbol => new <>f__AnonymousType1`2(symbol = symbol, name = value(LightStation.Storage.Relational.RelationalDbToBusinessObjectConverterExtensions+<>c__DisplayClass2).dateIdentifiers.Where(x => ((Convert(x.OrganizationId) == Convert(Organization.SelfId)) AndAlso (x.SymbolId.Value == symbol.id))).Select(x => x.Value))).Select(<>h__TransparentIdentifier0 => new <>f__AnonymousType2`2(<>h__TransparentIdentifier0 = <>h__TransparentIdentifier0, primaryTicker = value(LightStation.Storage.Relational.RelationalDbToBusinessObjectConverterExtensions+<>c__DisplayClass2).dateIdentifiers.Where(x => ((Convert(x.OrganizationId) == <>h__TransparentIdentifier0.symbol.symbolexchangeprimary.organization_id) AndAlso (x.SymbolId.Value == <>h__TransparentIdentifier0.symbol.id))).Select(x => x.Value).FirstOrDefault())).Select(<>h__TransparentIdentifier1 => new Symbol() {Id = new StationObjectID() {Value = <>h__TransparentIdentifier1.<>h__TransparentIdentifier0.symbol.id}, UniqueId = <>h__TransparentIdentifier1.<>h__TransparentIdentifier0.symbol.unique_id, TypeName = <>h__TransparentIdentifier1.<>h__TransparentIdentifier0.symbol.type_name, IsActive = <>h__TransparentIdentifier1.<>h__TransparentIdentifier0.symbol.is_active, StartDate = <>h__TransparentIdentifier1.<>h__TransparentIdentifier0.symbol.start_date, EndDate = <>h__TransparentIdentifier1.<>h__TransparentIdentifier0.symbol.end_date, Description = <>h__TransparentIdentifier1.<>h__TransparentIdentifier0.symbol.description, Extra = <>h__TransparentIdentifier1.<>h__TransparentIdentifier0.symbol.extra, DataProvenanceId = new NullableStationObjectID() {Value = <>h__TransparentIdentifier1.<>h__TransparentIdentifier0.symbol.data_provenance_id}, CountryId = new NullableStationObjectID() {Value = <>h__TransparentIdentifier1.<>h__TransparentIdentifier0.symbol.country_id}, CurrencyId = new NullableStationObjectID() {Value = <>h__TransparentIdentifier1.<>h__TransparentIdentifier0.symbol.currency_id}, DataProviderAccountId = new NullableStationObjectID() {Value = <>h__TransparentIdentifier1.<>h__TransparentIdentifier0.symbol.data_provider_account_id}, PrimaryExchangeId = new NullableStationObjectID() {Value = <>h__TransparentIdentifier1.<>h__TransparentIdentifier0.symbol.primary_exchange_id}, CompositeExchangeId = new NullableStationObjectID() {Value = <>h__TransparentIdentifier1.<>h__TransparentIdentifier0.symbol.composite_exchange_id}, Name = <>h__TransparentIdentifier1.<>h__TransparentIdentifier0.name.FirstOrDefault(), PrimaryTicker = <>h__TransparentIdentifier1.primaryTicker, AsOfDate = value(LightStation.Storage.Relational.RelationalDbToBusinessObjectConverterExtensions+<>c__DisplayClass2).asOfDate.Value}).First(x => (Convert(x.Id) == Convert(value(LightStation.Storage.Relational.Tests.IRelationalStorageTests.SymbolTests+<>c__DisplayClassa5).symbol.Id)))
205 ForEachProvider(db =>
206 Table(ls_symbol)
207 .Select(
208 // Unknown expression.
209 symbol => new <>f__AnonymousType1`2(symbol = symbol, name = value(LightStation.Storage.Relational.RelationalDbToBusinessObjectConverterExtensions+<>c__DisplayClass2).dateIdentifiers.Where(x => ((Convert(x.OrganizationId) == Convert(Organization.SelfId)) AndAlso (x.SymbolId.Value == symbol.id))).Select(x => x.Value)))
210 .Select(
211 // Unknown expression.
212 tp0 => new <>f__AnonymousType2`2(tp0 = tp0, primaryTicker = value(LightStation.Storage.Relational.RelationalDbToBusinessObjectConverterExtensions+<>c__DisplayClass2).dateIdentifiers.Where(x => ((Convert(x.OrganizationId) == tp0.symbol.symbolexchangeprimary.organization_id) AndAlso (x.SymbolId.Value == tp0.symbol.id))).Select(x => x.Value).FirstOrDefault()))
213 .Select(
214 // Unknown expression.
215 tp1 => new Symbol() {Id = new StationObjectID() {Value = tp1.tp0.symbol.id}, UniqueId = tp1.tp0.symbol.unique_id, TypeName = tp1.tp0.symbol.type_name, IsActive = tp1.tp0.symbol.is_active, StartDate = tp1.tp0.symbol.start_date, EndDate = tp1.tp0.symbol.end_date, Description = tp1.tp0.symbol.description, Extra = tp1.tp0.symbol.extra, DataProvenanceId = new NullableStationObjectID() {Value = tp1.tp0.symbol.data_provenance_id}, CountryId = new NullableStationObjectID() {Value = tp1.tp0.symbol.country_id}, CurrencyId = new NullableStationObjectID() {Value = tp1.tp0.symbol.currency_id}, DataProviderAccountId = new NullableStationObjectID() {Value = tp1.tp0.symbol.data_provider_account_id}, PrimaryExchangeId = new NullableStationObjectID() {Value = tp1.tp0.symbol.primary_exchange_id}, CompositeExchangeId = new NullableStationObjectID() {Value = tp1.tp0.symbol.composite_exchange_id}, Name = tp1.tp0.name.FirstOrDefault(), PrimaryTicker = tp1.primaryTicker, AsOfDate = value(LightStation.Storage.Relational.RelationalDbToBusinessObjectConverterExtensions+<>c__DisplayClass2).asOfDate.Value})
216 .First<LightStation.API.Symbol>(
217 // Unknown expression.
218 x => (Convert(x.Id) == Convert(value(LightStation.Storage.Relational.Tests.IRelationalStorageTests.SymbolTests+<>c__DisplayClassa5).symbol.Id))));
219 }
220 }
221 }
222
223 */