DataSet Design to database
-
Hi all, What is a better design in visual studio. To create separate datasets for each database table or one dataset with all tables on the dataset. Lets say the database has 30 tables. Just want to know your opinions! Regards Cecil
cecildt wrote:
What is a better design in visual studio.
Visual Studio is the IDE. You can do all this stuff in notepad if you want. It has nothing to do with Visual Studio.
cecildt wrote:
To create separate datasets for each database table or one dataset with all tables on the dataset.
Or don't use datasets at all. I don't use them much. I see no need for them. I query the database and everything gets mapped into my business objects.
Upcoming FREE developer events: * Glasgow: SQL Server Managed Objects AND Reporting Services ... My website
-
cecildt wrote:
What is a better design in visual studio.
Visual Studio is the IDE. You can do all this stuff in notepad if you want. It has nothing to do with Visual Studio.
cecildt wrote:
To create separate datasets for each database table or one dataset with all tables on the dataset.
Or don't use datasets at all. I don't use them much. I see no need for them. I query the database and everything gets mapped into my business objects.
Upcoming FREE developer events: * Glasgow: SQL Server Managed Objects AND Reporting Services ... My website
-
I know Visual Studio is the IDE. :laugh: Just want to know how people are using the DataSets. Thanks for your responds. O, use Notepad++ not notepad!
cecildt wrote:
Just want to know how people are using the DataSets.
I don't. I use business objects. Most serious advice on the subject recommends not using DataSets because of their being a bit overkill and their lack of type safety.
Deja View - the feeling that you've seen this post before.
-
Hi all, What is a better design in visual studio. To create separate datasets for each database table or one dataset with all tables on the dataset. Lets say the database has 30 tables. Just want to know your opinions! Regards Cecil
I've only started using datasets, so I'm no expert, but I favour one dataset per functional area. For example, I have one dataset for invoicing, with procucts, documents, and customers tables, where the customers table only has the customer data required for invoicing.
MY BLOG
Calling all South African developers! Your participation in this local dev community will be mutually beneficial, to you and us.
-
I know Visual Studio is the IDE. :laugh: Just want to know how people are using the DataSets. Thanks for your responds. O, use Notepad++ not notepad!
cecildt wrote:
use Notepad++ not notepad!
I was just saying that any two-bit text editor can be used.
cecildt wrote:
Just want to know how people are using the DataSets.
As Pete said, they shouldn't be using them in serious applications. For quick throw away or hobby applications they have their uses.
Upcoming FREE developer events: * Glasgow: SQL Server Managed Objects AND Reporting Services ... My website