Click here to Skip to main content
13,560,290 members
Rate this:
Please Sign up or sign in to vote.
See more:

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".

To switch DataContext connection I think I will have to do something like this:[^]

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.

Thank you
Posted 16-Jan-13 7:33am
Updated 16-Jan-13 8:39am
milenalukic 20-Jan-13 19:41pm
Are these custom fields columns for which you do not know the names?
If so how do you query them at present?
Belial09 21-Jan-13 2:57am
Yes I know the names of the custom columns.
We build add-ons to an existing software which has a function to add userdefined columns to the default SQL tables.

For Example:
The user has products in the programm with 4 columns, the ones without „USER_“ are default columns of the table (known columns):

- Price (default)
- Productnumber (default)
- USER_EAN (userdefined)
- USER_Pictureurl (userdefined)

At the moment we give them properties where they can add the custom field names, so we can query them in an SQLDataReaderusing an SQL-Query string.

- The tablename is known at design time
- The default table columns are known at design time
- The userdefined columns are only known at runtime

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1


In this case I don't know of a way that Linq can help you.

You either need to stick to your current way or look into dynamic SQL.

To be honest it's more of a case that if it works don't fix it!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Cookies | Terms of Service
Web01 | 2.8.180527.3 | Last Updated 21 Jan 2013
Copyright © CodeProject, 1999-2018
All Rights Reserved.
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100