Data Generator

CREATED ISSUE: Serialize Data Generators

JhonnyCano — Sat, 05 Apr 2008 14:08:17 GMT

It would be great if you can serialize the data generators, this because sometimes is boring to create every generator for each column of a table, and i want to save this job for later work,

CLOSED TASK: Update to VS2008

Allann — Sat, 23 Feb 2008 05:51:51 GMT

Update project to use VS2008

Source code checked in

Allann — Sat, 23 Feb 2008 05:51:50 GMT

Updated solution and projects ready for VS2008

CREATED TASK: Update to VS2008

Allann — Sat, 23 Feb 2008 05:47:58 GMT

Update project to use VS2008

NEW POST: Installation Instructions

Tatsu — Mon, 03 Sep 2007 13:49:41 GMT

I am trying to use this with VSTS for Database Professionals. Can you supply instructions for how I can install the binaries for use with DBPro?

Source code checked in

Allann — Tue, 27 Mar 2007 07:03:06 GMT

Added some comments and created a new test solution using the Microsoft test framework

NEW POST: Developer

Allann — Mon, 26 Mar 2007 23:39:53 GMT

Carlos if you are still interested please send another request to wbarthol as the email was not working at the time of your post.

We will be doing a little more work to this soon and any ideas you may have would be appreciated.

Project Management Forum: Developer

CarlosMPerez — Fri, 26 Jan 2007 16:53:26 GMT

Hello I'd like to help with this project. If you're willing to admit me, I'd like to talk with you about some ideas I have for this project. Regards, Carlos Manuel Perez

COMMENTED FEATURE: Add XmlDoc comments

wbarthol — Wed, 29 Nov 2006 10:44:22 GMT

Comments: Associated with changeset 12329.

CREATED FEATURE: Generate SDK documentation

wbarthol — Wed, 29 Nov 2006 10:31:20 GMT

CREATED FEATURE: Add XmlDoc comments

wbarthol — Wed, 29 Nov 2006 10:30:48 GMT

CREATED RELEASE: 1.0.0.0 Beta

Wed, 29 Nov 2006 10:20:24 GMT

UPDATED WIKI: Home

wbarthol — Wed, 29 Nov 2006 10:17:49 GMT

Introduction

DataGenerator is a set of strongly-typed random data generators that can be used for testing. All generators support generating a single value using Generate() or multiple values using Generate( count As Integer ).

Supplied Generators

Boolean Generator

   'Return True of False randomly.
   Dim gen As New BooleanGenerator()
   Console.WriteLine( gen.Generate() )

Choice Generator

   'Return either "Hello" or "World" randomly. Any data type is supported.
   Dim choices As New List(Of String)
   choices.Add( "Hello" )
   choices.Add( "World" )
 
   Dim gen As New ChoiceGenerator(Of String)( choices )
   Console.WriteLine( gen.Generate() )

Constant Generator

   'Always return the string "Hello World". Any data type is supported.
   Dim gen As New ConstantGenerator(Of String)( "Hello World" )
   Console.WriteLine( gen.Generate() )

DateTime Generator

   'Generate a random date between DateTime.MinValue and DateTime.MaxValue.
   Dim gen As New DateTimeGenerator()
   Console.WriteLine( gen.Generate() )

   'Generate a date in the past.
   Dim gen As New DateTimeGenerator( DateTimeGenerator.TemporalDirection.Past )
   Console.WriteLine( gen.Generate() )

   'Generate a date in the future.
   Dim gen As New DateTimeGenerator( DateTimeGenerator.TemporalDirection.Future )
   Console.WriteLine( gen.Generate() )

First Name Generator

   'Generates a random first name using the data from:
   'http://www.census.gov/genealogy/names/names_files.html
   Dim gen As New FirstNameGenerator()
   Console.WriteLine( gen.Generate() )

   'Only generate male names.
   Dim gen As New FirstNameGenerator( FirstNameGenerator.Genders.Male )
   Console.WriteLine( gen.Generate() )

   'Only generate female names.
   Dim gen As New FirstNameGenerator( FirstNameGenerator.Genders.Female )
   Console.WriteLine( gen.Generate() )

Guid Generator

   'Returns a globally unique identifier (Guid).
   Dim gen As New GuidGenerator()
   Console.WriteLine( gen.Generate() )

Integer Generator

   'Returns a random integer between 0 and Integer.MaxValue.
   Dim gen As New IntegerGenerator()
   Console.WriteLine( gen.Generate() )

   'Returns a random integer between -5 and 5.
   Dim gen As New IntegerGenerator( -5, 5 )
   Console.WriteLine( gen.Generate() )

Integer Sequence Generator

   'Returns 1, 2, 3, 4, etc.
   Dim gen As New IntegerSequenceGenerator()
   Console.WriteLine( gen.Generate() )

   'Returns 5, 10, 15, 20, etc.
   Dim gen As New IntegerSequenceGenerator( 0, 5 )
   Console.WriteLine( gen.Generate() )

Last Name Generator

   'Generates a random last name using the data from:
   'http://www.census.gov/genealogy/names/names_files.html
   Dim gen As New LastNameGenerator()
   Console.WriteLine( gen.Generate() )

Special Generators

These generators do not generate values directly but can be used to tailor the output from other generators.

Format Generator

   'Generate a list of first names prefixed with a row number.
   Dim rowNumberGenerator As New IntegerSequenceGenerator()
   Dim firstNameGenerator As New FirstNameGenerator()
   Dim gen As New FormatGenerator( "{0}. {1}", rowNumberGenerator, firstNameGenerator )
   Console.WriteLine( gen.Generate() )

Nullable Generator

   'Generate a random nullable-integer.
   Dim integerGenerator As New IntegerGenerator()
   Dim gen As New NullableGenerator(Of Integer)( integerGenerator )
   
   Dim value As Nullable(Of Integer)
   value = gen.Generate()
 
   If value.HasValue Then
      Console.WriteLine( value.Value )
   Else
      Console.WriteLine( "(NULL)" )
   End If

   'Generate a random nullable-integer with a 25% probability of NULLs.
   Dim integerGenerator As New IntegerGenerator()
   Dim gen As New NullableGenerator(Of Integer)( integerGenerator, 0.25 )
   
   Dim value As Nullable(Of Integer)
   value = gen.Generate()
 
   If value.HasValue Then
      Console.WriteLine( value.Value )
   Else
      Console.WriteLine( "(NULL)" )
   End If

Creating Your Own Generator

Simply implement IDataGenerator(Of T) or inherit from DataGeneratorBase(Of T). It is preferred to inherit from DataGeneratorBase(Of T) as it provides a default implementation of Generate( count As Integer) requiring you to only provide an implementation of Generate().

UPDATED WIKI: Home

wbarthol — Wed, 29 Nov 2006 10:16:06 GMT

Boolean Generator

   'Return True of False randomly.
   Dim gen As New BooleanGenerator()
   Console.WriteLine( gen.Generate() )

Choice Generator

   'Return either "Hello" or "World" randomly. Any data type is supported.
   Dim choices As New List(Of String)
   choices.Add( "Hello" )
   choices.Add( "World" )
 
   Dim gen As New ChoiceGenerator(Of String)( choices )
   Console.WriteLine( gen.Generate() )

Constant Generator

   'Always return the string "Hello World". Any data type is supported.
   Dim gen As New ConstantGenerator(Of String)( "Hello World" )
   Console.WriteLine( gen.Generate() )

DateTime Generator

   'Generate a random date between DateTime.MinValue and DateTime.MaxValue.
   Dim gen As New DateTimeGenerator()
   Console.WriteLine( gen.Generate() )

   'Generate a date in the past.
   Dim gen As New DateTimeGenerator( DateTimeGenerator.TemporalDirection.Past )
   Console.WriteLine( gen.Generate() )

   'Generate a date in the future.
   Dim gen As New DateTimeGenerator( DateTimeGenerator.TemporalDirection.Future )
   Console.WriteLine( gen.Generate() )

First Name Generator

   'Generates a random first name using the data from:
   'http://www.census.gov/genealogy/names/names_files.html
   Dim gen As New FirstNameGenerator()
   Console.WriteLine( gen.Generate() )

   'Only generate male names.
   Dim gen As New FirstNameGenerator( FirstNameGenerator.Genders.Male )
   Console.WriteLine( gen.Generate() )

   'Only generate female names.
   Dim gen As New FirstNameGenerator( FirstNameGenerator.Genders.Female )
   Console.WriteLine( gen.Generate() )

Guid Generator

   'Returns a globally unique identifier (Guid).
   Dim gen As New GuidGenerator()
   Console.WriteLine( gen.Generate() )

Integer Generator

   'Returns a random integer between 0 and Integer.MaxValue.
   Dim gen As New IntegerGenerator()
   Console.WriteLine( gen.Generate() )

   'Returns a random integer between -5 and 5.
   Dim gen As New IntegerGenerator( -5, 5 )
   Console.WriteLine( gen.Generate() )

Integer Sequence Generator

   'Returns 1, 2, 3, 4, etc.
   Dim gen As New IntegerSequenceGenerator()
   Console.WriteLine( gen.Generate() )

   'Returns 5, 10, 15, 20, etc.
   Dim gen As New IntegerSequenceGenerator( 0, 5 )
   Console.WriteLine( gen.Generate() )

Last Name Generator

   'Generates a random last name using the data from:
   'http://www.census.gov/genealogy/names/names_files.html
   Dim gen As New LastNameGenerator()
   Console.WriteLine( gen.Generate() )

Special Generators

These generators do not generate values directly but can be used to tailor the output from other generators.

Format Generator

   'Generate a list of first names prefixed with a row number.
   Dim rowNumberGenerator As New IntegerSequenceGenerator()
   Dim firstNameGenerator As New FirstNameGenerator()
   Dim gen As New FormatGenerator( "{0}. {1}", rowNumberGenerator, firstNameGenerator )
   Console.WriteLine( gen.Generate() )

Nullable Generator

   'Generate a random nullable-integer.
   Dim integerGenerator As New IntegerGenerator()
   Dim gen As New NullableGenerator(Of Integer)( integerGenerator )
   
   Dim value As Nullable(Of Integer)
   value = gen.Generate()
 
   If value.HasValue Then
      Console.WriteLine( value.Value )
   Else
      Console.WriteLine( "(NULL)" )
   End If

   'Generate a random nullable-integer with a 25% probability of NULLs.
   Dim integerGenerator As New IntegerGenerator()
   Dim gen As New NullableGenerator(Of Integer)( integerGenerator, 0.25 )
   
   Dim value As Nullable(Of Integer)
   value = gen.Generate()
 
   If value.HasValue Then
      Console.WriteLine( value.Value )
   Else
      Console.WriteLine( "(NULL)" )
   End If

Creating Your Own Generator

UPDATED WIKI: Home

wbarthol — Wed, 29 Nov 2006 10:07:30 GMT

Boolean Generator

   'Return True of False randomly.
   Dim gen As New BooleanGenerator()
   Console.WriteLine( gen.Generate() )

Choice Generator

   'Return either "Hello" or "World" randomly. Any data type is supported.
   Dim choices As New List(Of String)
   choices.Add( "Hello" )
   choices.Add( "World" )
 
   Dim gen As New ChoiceGenerator(Of String)( choices )
   Console.WriteLine( gen.Generate() )

Constant Generator

   'Always return the string "Hello World". Any data type is supported.
   Dim gen As New ConstantGenerator(Of String)( "Hello World" )
   Console.WriteLine( gen.Generate() )

DateTime Generator

   'Generate a random date between DateTime.MinValue and DateTime.MaxValue.
   Dim gen As New DateTimeGenerator()
   Console.WriteLine( gen.Generate() )

   'Generate a date in the past.
   Dim gen As New DateTimeGenerator( DateTimeGenerator.TemporalDirection.Past )
   Console.WriteLine( gen.Generate() )

   'Generate a date in the future.
   Dim gen As New DateTimeGenerator( DateTimeGenerator.TemporalDirection.Future )
   Console.WriteLine( gen.Generate() )

First Name Generator

   'Generates a random first name using the data from:
   'http://www.census.gov/genealogy/names/names_files.html
   Dim gen As New FirstNameGenerator()
   Console.WriteLine( gen.Generate() )

   'Only generate male names.
   Dim gen As New FirstNameGenerator( FirstNameGenerator.Genders.Male )
   Console.WriteLine( gen.Generate() )

   'Only generate female names.
   Dim gen As New FirstNameGenerator( FirstNameGenerator.Genders.Female )
   Console.WriteLine( gen.Generate() )

Guid Generator

   'Returns a globally unique identifier (Guid).
   Dim gen As New GuidGenerator()
   Console.WriteLine( gen.Generate() )

Integer Generator

   'Returns a random integer between 0 and Integer.MaxValue.
   Dim gen As New IntegerGenerator()
   Console.WriteLine( gen.Generate() )

   'Returns a random integer between -5 and 5.
   Dim gen As New IntegerGenerator( -5, 5 )
   Console.WriteLine( gen.Generate() )

Integer Sequence Generator

   'Returns 1, 2, 3, 4, etc.
   Dim gen As New IntegerSequenceGenerator()
   Console.WriteLine( gen.Generate() )

   'Returns 5, 10, 15, 20, etc.
   Dim gen As New IntegerSequenceGenerator( 0, 5 )
   Console.WriteLine( gen.Generate() )

Last Name Generator

   'Generates a random last name using the data from:
   'http://www.census.gov/genealogy/names/names_files.html
   Dim gen As New LastNameGenerator()
   Console.WriteLine( gen.Generate() )

Special Generators

Creating Your Own Generator

UPDATED WIKI: Home

wbarthol — Wed, 29 Nov 2006 10:06:45 GMT

Boolean Generator

   'Return True of False randomly.
   Dim gen As New BooleanGenerator()
   Console.WriteLine( gen.Generate() )

Choice Generator

   'Return either "Hello" or "World" randomly. Any data type is supported.
   Dim choices As New List(Of String)
   choices.Add( "Hello" )
   choices.Add( "World" )
 
   Dim gen As New ChoiceGenerator(Of String)( choices )
   Console.WriteLine( gen.Generate() )

Constant Generator

   'Always return the string "Hello World". Any data type is supported.
   Dim gen As New ConstantGenerator(Of String)( "Hello World" )
   Console.WriteLine( gen.Generate() )

DateTime Generator

   'Generate a random date between DateTime.MinValue and DateTime.MaxValue.
   Dim gen As New DateTimeGenerator()
   Console.WriteLine( gen.Generate() )

   'Generate a date in the past.
   Dim gen As New DateTimeGenerator( DateTimeGenerator.TemporalDirection.Past )
   Console.WriteLine( gen.Generate() )

   'Generate a date in the future.
   Dim gen As New DateTimeGenerator( DateTimeGenerator.TemporalDirection.Future )
   Console.WriteLine( gen.Generate() )

First Name Generator

   'Generates a random first name using the data from:
   'http://www.census.gov/genealogy/names/names_files.html
   Dim gen As New FirstNameGenerator()
   Console.WriteLine( gen.Generate() )

   'Only generate male names.
   Dim gen As New FirstNameGenerator( FirstNameGenerator.Genders.Male )
   Console.WriteLine( gen.Generate() )

   'Only generate female names.
   Dim gen As New FirstNameGenerator( FirstNameGenerator.Genders.Female )
   Console.WriteLine( gen.Generate() )

Guid Generator

   'Returns a globally unique identifier (Guid).
   Dim gen As New GuidGenerator()
   Console.WriteLine( gen.Generate() )

Integer Generator

   'Returns a random integer between 0 and Integer.MaxValue.
   Dim gen As New IntegerGenerator()
   Console.WriteLine( gen.Generate() )

   'Returns a random integer between -5 and 5.
   Dim gen As New IntegerGenerator( -5, 5 )
   Console.WriteLine( gen.Generate() )

Integer Sequence Generator

   'Returns 1, 2, 3, 4, etc.
   Dim gen As New IntegerSequenceGenerator()
   Console.WriteLine( gen.Generate() )

   'Returns 5, 10, 15, 20, etc.
   Dim gen As New IntegerSequenceGenerator( 0, 5 )
   Console.WriteLine( gen.Generate() )

Special Generators

Creating Your Own Generator

UPDATED WIKI: Home

wbarthol — Wed, 29 Nov 2006 10:03:42 GMT

Boolean Generator

   'Return True of False randomly.
   Dim gen As New BooleanGenerator()
   Console.WriteLine( gen.Generate() )

Choice Generator

   'Return either "Hello" or "World" randomly. Any data type is supported.
   Dim choices As New List(Of String)
   choices.Add( "Hello" )
   choices.Add( "World" )
 
   Dim gen As New ChoiceGenerator(Of String)( choices )
   Console.WriteLine( gen.Generate() )

Constant Generator

   'Always return the string "Hello World". Any data type is supported.
   Dim gen As New ConstantGenerator(Of String)( "Hello World" )
   Console.WriteLine( gen.Generate() )

DateTime Generator

   'Generate a random date between DateTime.MinValue and DateTime.MaxValue.
   Dim gen As New DateTimeGenerator()
   Console.WriteLine( gen.Generate() )

   'Generate a date in the past.
   Dim gen As New DateTimeGenerator( DateTimeGenerator.TemporalDirection.Past )
   Console.WriteLine( gen.Generate() )

   'Generate a date in the future.
   Dim gen As New DateTimeGenerator( DateTimeGenerator.TemporalDirection.Future )
   Console.WriteLine( gen.Generate() )

First Name Generator

   'Generates a random first name using the data from:
   'http://www.census.gov/genealogy/names/names_files.html
   Dim gen As New FirstNameGenerator()
   Console.WriteLine( gen.Generate() )

   'Only generate male names.
   Dim gen As New FirstNameGenerator( FirstNameGenerator.Genders.Male )
   Console.WriteLine( gen.Generate() )

   'Only generate female names.
   Dim gen As New FirstNameGenerator( FirstNameGenerator.Genders.Female )
   Console.WriteLine( gen.Generate() )

Guid Generator

   'Returns a globally unique identifier (Guid).
   Dim gen As New GuidGenerator()
   Console.WriteLine( gen.Generate() )

Integer Generator

   'Returns a random integer between 0 and Integer.MaxValue.
   Dim gen As New IntegerGenerator()
   Console.WriteLine( gen.Generate() )

   'Returns a random integer between -5 and 5.
   Dim gen As New IntegerGenerator( -5, 5 )
   Console.WriteLine( gen.Generate() )

Special Generators

Creating Your Own Generator

UPDATED WIKI: Home

wbarthol — Wed, 29 Nov 2006 10:00:35 GMT

Boolean Generator

   'Return True of False randomly.
   Dim gen As New BooleanGenerator()
   Console.WriteLine( gen.Generate() )

Choice Generator

   'Return either "Hello" or "World" randomly. Any data type is supported.
   Dim choices As New List(Of String)
   choices.Add( "Hello" )
   choices.Add( "World" )
 
   Dim gen As New ChoiceGenerator(Of String)( choices )
   Console.WriteLine( gen.Generate() )

Constant Generator

   'Always return the string "Hello World". Any data type is supported.
   Dim gen As New ConstantGenerator(Of String)( "Hello World" )
   Console.WriteLine( gen.Generate() )

DateTime Generator

   'Generate a random date between DateTime.MinValue and DateTime.MaxValue.
   Dim gen As New DateTimeGenerator()
   Console.WriteLine( gen.Generate() )

   'Generate a date in the past.
   Dim gen As New DateTimeGenerator( DateTimeGenerator.TemporalDirection.Past )
   Console.WriteLine( gen.Generate() )

   'Generate a date in the future.
   Dim gen As New DateTimeGenerator( DateTimeGenerator.TemporalDirection.Future )
   Console.WriteLine( gen.Generate() )

First Name Generator

   'Generates a random first name using the data from:
   'http://www.census.gov/genealogy/names/names_files.html
   Dim gen As New FirstNameGenerator()
   Console.WriteLine( gen.Generate() )

   'Only generate male names.
   Dim gen As New FirstNameGenerator( FirstNameGenerator.Genders.Male )
   Console.WriteLine( gen.Generate() )

   'Only generate female names.
   Dim gen As New FirstNameGenerator( FirstNameGenerator.Genders.Female )
   Console.WriteLine( gen.Generate() )

Special Generators

Creating Your Own Generator

UPDATED WIKI: Home

wbarthol — Wed, 29 Nov 2006 09:57:01 GMT

Boolean Generator

   'Return True of False randomly.
   Dim gen As New BooleanGenerator()
   Console.WriteLine( gen.Generate() )

Choice Generator

   'Return either "Hello" or "World" randomly. Any data type is supported.
   Dim choices As New List(Of String)
   choices.Add( "Hello" )
   choices.Add( "World" )
 
   Dim gen As New ChoiceGenerator(Of String)( choices )
   Console.WriteLine( gen.Generate() )

Constant Generator

   'Always return the string "Hello World". Any data type is supported.
   Dim gen As New ConstantGenerator(Of String)( "Hello World" )
   Console.WriteLine( gen.Generate() )

DateTime Generator

   'Generate a random date between DateTime.MinValue and DateTime.MaxValue.
   Dim gen As New DateTimeGenerator()
   Console.WriteLine( gen.Generate() )

   'Generate a date in the past.
   Dim gen As New DateTimeGenerator( DateTimeGenerator.TemporalDirection.Past )
   Console.WriteLine( gen.Generate() )

   'Generate a date in the future.
   Dim gen As New DateTimeGenerator( DateTimeGenerator.TemporalDirection.Future )
   Console.WriteLine( gen.Generate() )

Creating Your Own Generator

UPDATED WIKI: Home

wbarthol — Wed, 29 Nov 2006 09:54:16 GMT

Boolean Generator

   Dim gen As New BooleanGenerator()
   Console.WriteLine( gen.Generate() )

Choice Generator

   Dim choices As New List(Of String)
   choices.Add( "Hello" )
   choices.Add( "World" )
 
   Dim gen As New ChoiceGenerator(Of String)( choices )
   Console.WriteLine( gen.Generate() )

Constant Generator

   Dim gen As New ConstantGenerator(Of String)( "Hello World" )
   Console.WriteLine( gen.Generate() )

DateTime Generator

   Dim gen As New DateTimeGenerator()
   Console.WriteLine( gen.Generate() )

   Dim gen As New DateTimeGenerator( DateTimeGenerator.TemporalDirection.Past )
   Console.WriteLine( gen.Generate() )

Creating Your Own Generator