Multi-Property Uniqueness

• 
  Thanks for your post. Unfortunately, It's not possible to have data generated based on relationships between columns (unless it's PK > FK).
  
  I suppose in this instance, if the value of the integer isn't important, you could use a RegEx for each column that specified a value between certain values that was different for all columns, i.e:
  
  ShopNumber = 1 - 2000
  TillNumber = 2001 - 4000
  TicketNumber = 4001 - 6000
  
  Or something along those lines.
  
  HTH!
  
  Pete

  peter.peart January 12, 2012 08:37

  - 0 +
• 
  Peter:
  
  If this is not available off-the-shelf, could I do it with a custom generator?
  
  If this is (in theory) possible, I will look into writing one.
  
  Thanks,
  Martin.

  MartinH January 12, 2012 09:54

  - 0 +
• 
  Hi Martin,
  
  It should be possible. There's an article on our Simple Talk website which explains how to do this in more detail:
  
  http://www.simple-talk.com/dotnet/.net- ... generator/
  
  HTH!
  
  Pete

  peter.peart January 12, 2012 10:10

  - 0 +
• 
  Peter:
  
  Yes, that will work fine. I'll write my own generator to support this scenario,
  
  Thanks for the help.
  
  Regards,
  Martin.

  MartinH January 19, 2012 13:26

  - 0 +

Add comment

Please sign in to leave a comment.