[Mono-list] .Net Membership API Support

[Kellner, Peter]

I'm currently putting together a mysql provider that works with odbc
3.51 under windows.  Haven't done much with mono yet.  Was hoping it was
done here and I could use it.  Time permitting, I'd be happy to
contribute and help with the mysql provider.  I basically converted the
sqlserver tables to mysql and was going to go from there.  I was hoping
not to use much in the way of SP's. so it  will work with earlier
version of mysql.  Microsoft used quite a few sp's in there
implementation.

-----Original Message-----
From: Ben Maurer [mailto:bmaurer at ximian.com] 
Sent: Monday, November 14, 2005 7:31 PM
To: Kellner, Peter
Cc: mono-list at lists.ximian.com
Subject: RE: [Mono-list] .Net Membership API Support

On Mon, 2005-11-14 at 21:43 -0500, Kellner, Peter wrote:
> Speaking of Membership, is anyone working on that class?  If so, is
the
> plan to make a provider for mysql since Microsoft does not have that?

Well, there are some basic stubs that I did (a long time ago). But
AFAIK, nobody is working on implementing one of the providers.

IMHO, SqlMembershipProvider (if it is implemented) should be written so
that it queries a mssql server with the schema that msft's framework
uses -- there would be some value to being able to share an
authentication database with apps that are written on windows. Also, if
somebody wants to quickly migrate an application from windows to linux,
it may be easiest to first do the web part, then the db part. (in fact
one app that I am working on for school would benefit greatly from being
able to attach to the MSFT schema).

If we want to have a provider that uses a free database (which is
needed), it should probably be a mono specific assembly (that way people
on Windows can use it too, if they don't want to pay > $1000 for
sqlserver (and for some reason can't use don't want sqlexpress). We
could still make this class the default in Mono's machine.config, so
that things worked out of the box (however, for this to really work,
we'd need something like sqlexpress's database attaching).

In terms of mysql, pgsql might be a better choice as the mysql provider
is now GPL and we are no longer updating it from upstream.

-- Ben