I'm using wizard to add tables to my project to work with them. Is having just one datasource for project better way? At the moment there is only 5 tables.
POST EDIT It's so cumbersome and I'm feeling myself going wrong way to use wizard, that makes another one dataset for every table, so I thought about just one dataset for my little application. But as I have little experience with ADO .NET, I hope to get advice here.
I find it's much easier to maintain an application when features of the system are isolated from one another. So in this instance having a dataset, one for each way the system is accessed, would make it easier to maintain.
an example of how this plays out:
this is probably overkill for a system of 5 tables, but if you can train yourself to think in context specific usages, it makes it much easier to expand and change the system moving forward.