Short question: how to fit TableAdapters into (true) n-tier development.

More Info:
In VS2003 in terms of *physical* n-tier development, I had a fairly nice
pattern going. My DAL exists on a separate server and accessed via remoting.
In order for the client machine to "know" about the classes and methods on
the server (rather than going the lazy route and installing the server dll's
on the client) I have a very lightweight dll that contains "Types and
interfaces" that is installed  on both the server and client.

This DLL acts as a WSDL file of sorts.... it contains datasets, classes, and
most importantly *interfaces* for the data access methods on the server (all
methods on the server must implement a particular Interface). This is not
hard to do and it's great because I can write a new server from the ground
up that contains the same methods but totally different implementation
without ever touching the client (at all!).

But, now in VS2005 / ADO.NET 2.0 I have a problem. I really really really
like the TableAdapter classes and the IDE designer for it. But am purplexed
that I can't PHYSICALLY separate it from the Dataset. My old pattern called
for the Datasets to exist in the "Types and Interfaces" DLL (because the
client uses them too) and the DataAdapters to exist on the remoted Server
DLL.

Anyone have any ideas on how I can adapt TableAdapters to this paradigm? I
absolutely hate the idea of putting my data access code on the client...
even if it's only going to get executed on the server. It violates the whole
notion of N-TIER development (logical layers is not the same as N-Tier...
though everyone seems to have forgotten this... including Microsoft).

P.S. I know I can continue to use DataAdapters. But, TableAdapters are way
easier to configure.

CMM,

Did you already tried the WebService. In my idea is it exactly doing what
you want.

See this sample, which has a lot of typos (the C# code is in the VBNet code
without a new paragraph by instance) in it and there is one real error.

There is used in the sample
Datatable.haschanges, a pity, because strange enough does that not exist.

A workaround for that is.
"(Datatable.Getchanges) IsNot Nothing" (I have seen that you use VB code in
the language.vb newsgroup).

http://msdn2.microsoft.com/en-us/library/1as0t7ff.aspx

I hope this gives some idea's

Cor

Yes,you're right. Web services solve my problem because the WSDL file
describes all the objects being exposed and allows the server classes to be
reconstructed on the client without the implementation actually existing on
it.

Unfortunately, performance is a #1 requirement of my projects (where offices
are linked via VPN) and the overhead of XML on every round-trip is not
justifiable in any way whatsoever. Remoting is the only way to go for us.


Show quoteHide quote

SqlTransaction problems
click event handler executed twice
What causes SqlCommandBuilder to not build commands?
date/time fields
VB.NET - How do I return an AutoNumber from an Insert Statement using the DataGridView