asp.net mvc - Websecurity.CreateUserAndAccount on Azure doesn't work -
i have method registers new user using websecurity.createuserandaccount(model.username, model.password) problem in userprofile model have added guid key. on local machine populates empty guid when call method. on azure however, following error:
system.data.sqlclient.sqlexception (0x80131904): cannot insert value null column 'key', table 'scheduler.dbo.userprofile'; column not allow nulls. insert fails. now, i've tried generate new guid in constructor of model, manually have set{} generate new guid , same error.
when try use createuserandaccount overload like:
websecurity.createuserandaccount(model.username, model.password, new { key = guid.newguid() }); i following syntax error (run time):
incorrect syntax near keyword 'key'. i've spent part of morning trying figure out , can't. way of above methods still result in empty guid 00000000-0000-0000-0000-000000000000 , overload gives me syntax error on local machine.
"key" reserved word in sql, should used in brackets [key]
since don't have control on how websecurity generate sql query option rename userkey
Comments
Post a Comment