Datatables and TableAdapters in separate files

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



I've been using the VS 2005 wizards to generate strongly-typed datasets,
datatables, and table adapters for a client/server application. I use the
table adapters on the server to connect to the database and retrieve
datatables. I then return those datatables to the client. I would really
like to have the datatable definitions in one assembly (distributed with the
client application) and the tableadapters in another assembly (only needed
on the server, has a bunch of code and connection strings).

It was fairly easy to split them up manually and compile them into separate
assemblies. Of course, once I do that the designer can't handle the
tableadapters any more so it makes it very difficult to upgrade and maintain
them.

It would be nice if the VS designer allowed us to generate them separately
so they could be compiled into separate assemblies.

Anybody have any thoughts/ideas on this? What is the underlying tool that
VS uses to generate table adapters? Perhaps it supports this kind of thing.

Joel

.



Relevant Pages

  • Re: Datatables and TableAdapters in separate files
    ... Your data adapters are separated from the dataset. ... datatables, and table adapters for a client/server application. ... It was fairly easy to split them up manually and compile them into separate ... so they could be compiled into separate assemblies. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Datatables and TableAdapters in separate files
    ... Create a separate project ... Your data adapters are separated from the dataset. ... datatables, and table adapters for a client/server application. ... so they could be compiled into separate assemblies. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Dataset neufüllen?
    ... Nach Update des Data-Adapters sind die neuen Daten zwar in der ... neufüllen lasse ist die Anzeige korrekt? ... nur diese DataTables mit nachfolgendem Update (Datenhaltung im Client anb ... die der aktuelle Client mitbekommen soll. ...
    (microsoft.public.de.german.entwickler.dotnet.datenbank)
  • Re: Datatables and TableAdapters in separate files
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... datatables, and table adapters for a client/server application. ... so they could be compiled into separate assemblies. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cant seem to speed up Rows.Add in DataTable
    ... You do first an insert from your clienttable on the database server from ... First of all I have 2 datatables, ServerTable and ClientTable, ... ClientTable exists on the client. ... DataRow drClient = ...
    (microsoft.public.dotnet.framework.adonet)