I'm having a problem in creating an account. When I clicked the button register. I'm getting this error.


The column name is not valid. [ Node name (if any) = ,Column name = Email ]
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlServerCe.SqlCeException: The column name is not valid. [ Node name (if any) = ,Column name = Email ]

Source Error:


Line 37: var user = new {FirstName = firstname, LastName = lastname, Email = email};
Line 38: try{
Line 39: var token = WebSecurity.CreateUserAndAccount(username, password, user, true);
Line 40: var hostUrl = Request.Url.GetComponents(UriComponents.SchemeAndS erver, UriFormat.Unescaped);
Line 41: var confirmationUrl = hostUrl + VirtualPathUtility.ToAbsolute("~/Account/Confirm?confirmationCode=" + HttpUtility.UrlEncode(token));


Source File: c:\BegASPNET\Site\Classifieds\Account\Register.csh tml Line: 39



Pls. help me guys. I'm getting an error in line 39.

There's a typo on page 310 where it specifies that the column name should be "E-mail". That should read "Email". The easiest thing to do is to drop the column named "E-mail" and add another called "Email"