Typed dataset and adapters

[Clive Dixon]

I want to create a typed dataset via Visual Studio but I don't want any of
the SQL adapters stuff. I just want a typed dataset, no need to connect to a
database. How can I stop Visual Studio from generating all that stuff?

 

[Alberto Poblacion]

I want to create a typed dataset via Visual Studio but I don't want any of
the SQL adapters stuff. I just want a typed dataset, no need to connect to
a database. How can I stop Visual Studio from generating all that stuff?

This is one way in which you can do it:
In Visual Studio 2008, Add a New item to your project. Select DataSet,
and name it whatever.xsd. You get a blank, blue-colored, design surface.
Right-click on the surface and select "Add Table". Then configure your table
by adding columns. This will generate only the table in the dataset, without
any tableadapters.

 

[Clive Dixon]

This is one way in which you can do it:
In Visual Studio 2008, Add a New item to your project. Select DataSet,
and name it whatever.xsd. You get a blank, blue-colored, design surface.
Right-click on the surface and select "Add Table". Then configure your
table by adding columns. This will generate only the table in the dataset,
without any tableadapters.

Thanks for the suggestion, but I am working with a pre-existing database
with many tables - manual creation is not an option. I want to be able to
autogenerate my dataset by drag drop, but I don't want any adapter code with
it. I was hoping there would be some setting somewhere to stop this being
generated.