CODEWITHSUNDEEP
c#.netado.netdataset
yucer
yucer

Reputation: 5049

import database schema from database to a DataSet (with DataRelations)

I'm trying to import the schema of NorthWind database to DataSet using VS2010, and .Net Framework 4.

I have tried to use the designer and the FillSchema method, but neither of those ways let me import the relations so that i have to specify them by hand on the designer or by code.

The relations information is on the Database schema.

Had anybody retrieved all the relations successfully without specify them one by one ?

PS: I'm accessing the database by ODBC (postgresql and MDB drivers tested).

Upvotes: 0

Views: 852

Answers (1)

Harrison
Harrison

Reputation: 3963

Although I have not used NorthWind the steps to do this with MSQL are as follows

  1. Create the data relations in the database itself

  2. In Visual Studio go to the Data Sources window (View > Other Windows > Data Sources or Shift-alt-D)

  3. Click Add a New DataSource Icon which will bring up the Data Source Configuration Wizard

The Data Source Configuration Wizard creates and edits data sources in your application. These data sources can be made from databases, services, or objects.

  1. Once you follow the instructions on the link above to select a Database, and select a database model of a dataset, give it a connection string and select your tables, you should see a file in your solution for the dataset. Open this up to see the database diagram which will include your database relationships, aka foriegn keys.

Upvotes: 1

Related Questions