Possible to use Tables of same type in Linq to SQL?
- by Schneider
Lets say I've got an object model, where I have many collections of the same type.
For example something like
class StockMarketData {
List<SummaryData> WeeklySummary;
List<SummaryData> MonthlySummary;
}
class SummaryData {
DateTime DateTime {get; set;}
double Value {get; set;}
}
Those lists will map onto database tables.
If you actually use L2S to generate a model from the database you will get something like:
class StockMarketData {
List<WeeklySummaryData> WeeklySummary;
List<MonthlySummaryData> MonthlySummary;
}
Even though WeeklySummaryData and MonthlySummaryData have the same shape.
Is it possible for Linq to SQL to create tables from a database of summary data, but get each table to contain the same type (such as shown in the top example).
