Re: Datatables and TableAdapters in separate files

Tech-Archive recommends: Fix windows errors by optimizing your registry

Download the Orcas beta. See if their new approach is easier to use.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"Joel Lyons" <joell_REMOVE_@xxxxxxxxxxx> wrote in message
news:OmosvL1vHHA.2352@xxxxxxxxxxxxxxxxxxxxxxx
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)
  • SQLClientPermission problem
    ... The database is on Machine 1. ... Both machines have SQL Server 2005 Express installed. ... assemblies on my local intranet signed with my strong name. ...
    (microsoft.public.dotnet.security)
  • Re: SQL Server 2005: CLR functions vs SQL functions
    ... CREATE PROCEDURE my_sharp_proc @a int, @b int WITH LANGUAGE C# AS ... me from having to copy the assemblies to the production server. ... to wait for SQL Server 2010 for that. ...
    (comp.databases.ms-sqlserver)
  • DataTable creating question?
    ... I have a large table in Sql Server that I want to populate ... from these 2 separate dataTables into a dataTable that I ... But dt1 and dt2 turned out to be the same table. ... tbl1 ...
    (microsoft.public.dotnet.framework.adonet)