My ISAPI/Datasnap nightmare continues.

My ISAPI/Datasnap nightmare continues.  

As you know with MVC 5 & Identity table structures got changed . Login credentials are now saved to ASPNetUsers table.

Now here is the problem.

Earlier  important login validation fields where Password nvarchar(128) & PasswordSalt nvarchar(128) in table aspnet_Membership .
Now with asp.net identity its in table AspNetUsers and fields are PasswordHash nvarchar(max)and SecurityStamp  nvarchar(max).

Whenever my delphi isapi server does select  statement on fields that are of nvarchar(max) it throws 500 error.

Question is why do we need nvarchar(max) for these fields and why is ISAPI not liking nvarchar(max) ??

Thanks.

Comments