Strongly typed Datasets and TableAdapter separation.

[Max2006]

Hi,

I would like to have all my strongly typed datasets in a classlibrary.dll
and share the DLL across all solution tiers. The serious problem with this
approach is that I cannot separate TableAdapters from DataSets.

Is there any possible way to separate TableAdapter s from strongly typed
datasets?

Any help would be appreciated,
Max

 

[Linda Liu[MSFT]]

Hi Max,

The TableAdpter class is not part of the .NET Framework and as such you
cannot look it up in the documentation or the Object Browser. It is created
at design time when you use either the Data Source Configuration Wizard or
the TableAdapter Configuration Wizard.

When a TableAdapter is created at design time, it always has a DataTable
associated with it. The initial query or stored procedure of the
TableAdapter is used to define the schema of the associated DataTable. We
cannot separate the associated DataTable from the TableAdapter.

In your scenario, you needn't seperate TableAdapters from DataSets at all.
If you really want to do that, you may consider using the DataAdapter
instead of the TableAdapter.

For more information on TableAdapter, see the following MSDN document:
http://msdn.microsoft.com/en-us/library/bz9tthwx(VS.80).aspx

Hope this helps.
If you have any question, please feel free to let me know.

Sincerely,
Linda Liu
Microsoft Online Community Support

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Cor Ligthert[MVP]]

Max,

I don't see your problem,

I was curious what it could be, so I created a new Library project, I added
an item dataset, I rightclicked on the surface and told that a datatable
should be made. Then I set in Explorer view thow all files to true.

There was a nice dataset1.designer.VB class that I could use in that DLL.

I never use the tableadapter as I find it a disprovement they never should
have made, this newsgroup is full of confusions about it.

As you use the real DataAdapter as Linda describes, you have then much more
possibilities.

Cor

 

[Linda Liu[MSFT]]

Hi Max,

I do more research on this issue and have some new findings.

In VS2005, we cannot separate DataSets and TableAdapters. But in VS2008, we
can separate DataSets and TableAdapter into two different projects.

Note that the two projects should be in the same solution. For more
information on how to do this, see the following MSDN document:
http://msdn.microsoft.com/en-us/library/bb384586.aspx

If you're using VS2008, you can follow the steps introduced in the above
MSDN document to separate DataSets and TableAdapters.

If you're using VS2005, you may take my suggestion in my first reply.

If you have any question, please feel free to let me know.

Sincerely,
Linda Liu
Microsoft Online Community Support

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Cor Ligthert [MVP]]

As I tried it in VS2008



Cor

 

[Max2006]

Hi Linda,

This is really great! You made my day.

I was desperate for this feature since 2005. Thank you very much for help.

Many thanks....Max

 

[Linda Liu[MSFT]]

Hi Max,

Thank you for your feedback and you're welcome!

If you have any other questions in the future, please don't hesitate to
contact us. It's always our pleasure to be of assistance!

Have a nice day.

Sincerely,
Linda Liu
Microsoft Online Community Support

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).

This posting is provided "AS IS" with no warranties, and confers no rights.