another Linq questions for you smart folks...!

Ilyas

Hi all

I have a database that contains several tables. Each table has the
name data01, data02, data03 etc

The column definitions for each table all contains several standard
columns and then several custom columns. There are no foreign keys or
anything like that!

My questions is it it possible to use "linq to sql" in this scenario
to: Allow me to retreieve data from each "data" table, and get back a
strongly typed object? How would this work for the custom columns that
are defined on each linq table. Furthermore any new tables would I be
be to use Linq to sql against them? New tables are created by
different applications and I have no controls over this aspect

If its not possible to use Linq, what other options do I have to get
access to the data to perform simple crud operations?

Many thanks

Jun 27 '08 #1

Subscribe Post Reply

1389

Marc Gravell

I think at this point any benefit from LINQ would be lost; if the
tables were the same (or you only cared about the fixed part) you
could *just about* use an XmlMappingSource and a single type (with
different mappings each time), but you'd have to talk to each table in
a different data-context. Other than that, you're into dynamic type
generation (through any of: reflection, CodeDom, dynamic compilation,
etc) - which is not an area to be taken lightly.

Now; I am not a fan of DataTable etc - but in this case, I suspect
that this will be your most pragmatic option... i.e. have an (untyped)
DataSet, to which you add the necessary tables, each with the
necessary columns. Ditto adapters...

Marc

Jun 27 '08 #2

Similar topics

while c = f.read(1)

by: Greg McIntyre | last post by:

I have a Python snippet: f = open("blah.txt", "r") while True: c = f.read(1) if c == '': break # EOF # ... work on c Is some way to make this code more compact and simple? It's a bit...

Python

using Linq with .NET 2.0

by: martin | last post by:

I'm just wondering... Will it be possible to use C# 3.0 and Linq to objects without having our users download the .NET Framework 2.0 client? I really would like to use the C# 3.0 features, but I...

C# / C Sharp

Linq & List.Contains

by: Andy | last post by:

Hi, I'm trying to add a where clause to my query: List<stringtypes = new List<string>(); types.Add( "A" ); types.Add( "B" ); query = query.Where( c =types.Contains( c.Type ) );

C# / C Sharp

Linq - basic simple Answer

by: =?Utf-8?B?cmF1bGF2aQ==?= | last post by:

Hi all: after reading different places/sites about linq... I ran into these questions: 1. What framework do we need to run linq ? (does it depend on what version of visual studio we have?) how...

C# / C Sharp

Discussion: linq vs stored procedures

by: Arjen | last post by:

Hi, My experience with linq is that I can develop my web application very fast. On the other hand, I have read that using stored procedures are executing faster. Is it smart to use linq for a...

C# / C Sharp

Re: Linq to Python

by: hrishy | last post by:

Hi Terry Oops i never realised the mistake i have commited I apologise (i thought changing the subject line would make a new thread) I apologise (I thought Python programmers were smart and...

Python

Linq > Group

by: shapper | last post by:

Hello, I have the following Linq query: List<PostsTaginsert = (from t in (from t in database.Tags join p in paper.Tags on t.Name equals p.Name select t).ToList() select new PostsTag {

C# / C Sharp

linq vs lambda

by: CSharper | last post by:

I have following XML <root> <Person id="1"> <Name>a</Name> </Person> <Person id="2"> <Name>b</Name> </Person> </root>

C# / C Sharp

Linq or not Linq

by: George | last post by:

I am a bit conservative type and usually give some time for technology to mature before starting to try it. Today my question is Linq. To start using it or not. So here is the voting questions....

ASP.NET

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General