Using a GUID for a MySQL Membership Provider User

Question

I am using MySql membership provider with .NET MVC 4 application and have configured it according to this tutorial .

The problem is that the provider sets up the table mysql_aspnet_userswith UserID PK as INT(11), while the MSSQL provider uses UNIQUEIDENTIFIER.

I need to transfer existing users to this database, and I would prefer to save the Guid"Users" and "Membership" tables as the primary key.

Is there a way to do this using the MySql membership provider ?

Or do I need to write my own MySql membership provider to use UUIDsas primary keys?

I searched for any documentation or “non-hacked” ways to do this, but so far no luck.

Answer 1

I don't think you can prevent the creation of a custom user membership class with a custom membership provider. Something like this tutorial http://msdn.microsoft.com/en-us/library/ms366730%28v=VS.85%29.aspx they use the GUID as well. You need to modify SQL abit to work with MySQL

Answer 2

CHAR (16), . varchar (36), .

---

http://mysqlbackupnet.codeplex.com/wikipage?title=Using%20MySQL%20With%20GUID%20or%20UUID

Answer 3

MySql .NET, Dolphin https://github.com/film-skills/dolphin-net! , GUID Integer. , ! NuGet http://www.nuget.org/packages/Dolphin/0.0.2