0

I have to design a database for customer with email id as login but since we have lots of data we need to use federation but since we cant have string or varchar or nvarchar as federation key I am stuck at what should I do. User will use email id to login. How can I solve this problem? Please help me.

manishkr1608
  • 313
  • 1
  • 3
  • 13

1 Answers1

0

You can use varbinary column, and populate the varbinary column with the hash of the email address.

IMHO using an email address as a Federation key does not seem like a good design idea though

pateketu
  • 451
  • 2
  • 8
  • 1
    Yes, email address as a Federation key sounds like a terrible idea. – Craig Nov 19 '13 at 11:06
  • What I was planning is to have a table in root DB which will have email and Id as field then the federation will start on Id field...Let me know your thoughts....Thanks...:) – manishkr1608 Nov 19 '13 at 12:15
  • 1
    That sounds ok if the federation is on the ID. I have a similar setup with an Organisation table and OrganisationId is the federation key. – Craig Nov 19 '13 at 22:13