I just downloaded the source code for 2.1.0 Beta 1 and started testing the provider. Over all you have done a good job of cleaning up the scripts so that they will run. I attempted to run the provider scripts to create the database for the membership provider, and ran into just a few snags.
1. FirebirdMemberShipProvider1.5.sql script still references a table that is not created until you run the FbRoleProvier1.5 script. The exact line looks like this. (USERSINROLE table is not created until after you run the role provider script.) >CREATE PROCEDURE MEMBERSHIP_DELETEUSER ( > APPLICATIONNAME VARCHAR(255) CHARACTER SET UNICODE_FSS, > USERNAME VARCHAR(252) CHARACTER SET NONE, > DELETEALLRELATEDDATA INTEGER) >RETURNS ( > RETURNCODE INTEGER) >AS >DECLARE VARIABLE PKID CHAR(16) CHARACTER SET OCTETS; >DECLARE VARIABLE VNAME VARCHAR(252) CHARACTER SET NONE; >BEGIN > SELECT PKID,USERNAME FROM USERS WHERE UPPERUSERNAME = UPPER(:USERNAME) AND APPLICATIONNAME = :APPLICATIONNAME INTO :PKID,:VNAME; > IF (VNAME IS NULL) THEN > RETURNCODE = -1; > ELSE > BEGIN > RETURNCODE = 1; > DELETE FROM USERS WHERE PKID = :PKID; > IF (DELETEALLRELATEDDATA = 1) THEN > BEGIN > DELETE FROM USERSINROLES WHERE USERSINROLES.USERNAME = :VNAME AND APPLICATIONNAME = :APPLICATIONNAME; -- Remove if you don't use role provider > --DELETE FROM PROFILES WHERE PROFILES.PKID = :PKID; -- put if you use profile provider > END > END > > SUSPEND; >END^ 2. The profile provider recreates the domain BOOL. This should be omitted when creating the table in the existing database, and noted to include if you are creating a separate database. >CREATE DOMAIN BOOL AS >SMALLINT >NOT NULL >CHECK (value=1 or value=0 or value is null); 3. Where is the Web-Provider documentation on how to make the black box work? Although I have taken the time to learn the provider model and how it works, there seems to be a rash of how do I make this black box work questions on the news group. Would you like some help with formal documentation on this? Maybe a document should be drafted on how to run the scripts by merging them together so that there is no error. I think this might lower the frustration level with some developers. The Firebird project, and .net provider is excellent. You are on the home stretch of making this product a viable alternative to most other rdbm systems. I have looked over the source code very carefully, and I feel that your code has better readability that most and has sound practices behind it. Keep up the good work. Thanks, Steven R. ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
