I am trying to learn how LINQ to SQL works.
So far it seems like it's exactly what I need, but at work I do often have the following scenario:
The development PC has a default database with e.g. a table named "tTable1", Columns "Price" and "Customer".
The Customer PC has the same database but with e.g. a Table named "tTable1" (same name) and Columns "Price", "Customer" + "UserdefinedColumn1","UserdefinedColumn2".
connection I think I will have to do something like this: http://steveclements.net/blog/Dynamic-connection-for-LINQ-to-SQL-DataContext
But what about the Custom Fields in the Table, the class does not contain them as property? How can I "query" them?
Can I use LINQ to SQL in this scenario or do I need to use LINQ to Dataset so that I can read the custom Fields in a dataset?
Any suggestions or links welcome.