If you want to be able to generate random and realistic data for your program, there is a fantastic free resource called Mockaroo.

It lets you create your list of fields and their types.

You can also decide, on a field by field basis, what percentage of records will return as blank.


When you have finished, you can press download. This will generate up to 1000 lines of data for free and you can choose from a variety of output formats to export it as. You can even save your schema to use again later, if you sign up for a free account.

Have a look at it and let me know if you find it useful.



Thanks to .NET Rocks for letting me know about this site in the first place.

About the author

Paul Seal

A .NET Web Developer from Derby (UK) who specialises in building Content Management System (CMS) websites using MVC with Umbraco as a framework. Paul is passionate about web development and programming as a whole. Apart from when he's with his wife and son, if he's not writing code, he's thinking about it or listening to a podcast about it.

Related Posts

How to show UTC time relative to the user's local time on a .NET website

This post gives you the code I found to help you get a user's country and culture code and display a…

Read Post

What is TDD? How to get started with Test Driven Development

This post gives you an introduction into Test Driven Development. It uses a simple, real world examp…

Read Post

How to migrate or downgrade a SQL Server database to a lower version

This post shows you how you can migrate or downgrade a SQL Server database from one version to a low…

Read Post

How to convert SQL Server Compact Edition .sdf to Full SQL and speed up Umbraco

This post shows you how to convert a SQL Compact Edition database to full SQL and speed up Umbraco

Read Post