Is there a tool for filling a System.Data.Dataset with test data?
+1
A:
Is the dataset in question already have a defined schema or are you just needing some/any test data?
If any data will do Northwind is a test db you can use for sample business data:
chief7
2009-03-23 12:18:57
A:
I'd suggest that using a tool to generate the test data once and store it in a database from which you could repeatably fill the dataset would be a better solution. There are several tools that you could use to do this: Red Gate SQL Data Generator, EMS Data Generator, etc.
tvanfosson
2009-03-23 12:20:13
*Just* before hitting enter, I see "1 Response Posted..." - I should have known you'd beat me to it!
Mark Brittingham
2009-03-23 12:21:48
I'm not quite sure this is what I am after. These tools seem to create the data in a database whereas I am looking to fill a typed dataset at runtime with data.
JDKing
2009-03-23 12:27:04
@JDKing -- I understand. I'm suggesting that the way to do is to generate the data once and store it in a database, then simply load it each time you want to populate the dataset. If you find bugs that aren't caught using the initial random data you can always add new data by hand to cover them.
tvanfosson
2009-03-23 15:00:20
Thanks for your suggestion. I see where you are coming from, but I'd rather not have the dependency on a database.
JDKing
2009-03-23 16:28:33
A:
Check out the Data Generator tool from Red Gate. I recommend anything they build but I think this one does just what you're asking for.
Mark Brittingham
2009-03-23 12:21:09