System.Data.SQLite

using System.Diagnostics;
using System.Web;
using System.Globalization;
using System.Security.Cryptography;
using System.Text;
using System.Web.Configuration;



namespace SQLiteProvider
{

    public sealed partial class SQLiteMembershipProvider : MembershipProvider
    {
        private bool _initialized = false;
        private Object _InitLock = new Object();
        public override void Initialize(string name, NameValueCollection config)
        {
            bool te = _initialized;
            if (te)
                return;

            lock (_InitLock)
            {

                if (config == null)
                    throw new ArgumentNullException("config");

                if (name == null || name.Length == 0)

                _RequiresQuestionAndAnswer = ConfigAsBoolean(config["requiresQuestionAndAnswer"], false);
                _RequiresUniqueEmail = ConfigAsBoolean(config["requiresUniqueEmail"], true);


                string temp_format = Convert.ToString(ConfigAsString(config["passwordFormat"], "Hashed"));
                try
                {
                    _PasswordFormat = (MembershipPasswordFormat)Enum.Parse(MembershipPasswordFormat, temp_format);
                }
                catch
                {
                    throw new ProviderException("Invalid Password Format.");
                }

namespace SQLiteProvider
{

    public sealed partial class SQLiteMembershipProvider : MembershipProvider
    {

        //
        // Global connection string, generated password length, generic exception message, event log info.
        //

        private int newPasswordLength = 8;
        private string eventSource = "SQLiteMembershipProvider";

        private string connectionString;
        private bool _WriteExceptionsToEventLog;
        private MachineKeySection machineKey;
        private string _ApplicationName;
        private long _AppID;
        private bool _EnablePasswordReset;

namespace SQLiteProvider
{

    public sealed partial class SQLiteMembershipProvider : MembershipProvider
    {
        //
        // CheckPassword
        //   Compares password values based on the MembershipPasswordFormat.
        //

        private bool CheckPassword(string password, string dbpassword)

namespace SQLiteProvider
{

    public sealed partial class SQLiteMembershipProvider : MembershipProvider
    {
        private Object _appLock = new Object();
        public override string ApplicationName
        {
            get { return _ApplicationName; }
            set
            {

using System.Globalization;



namespace SQLiteProvider
{

    public sealed partial class SQLiteRoleProvider : RoleProvider
    {


        private string eventSource = "SQLiteRoleProvider";

        private string connectionString;
        private bool _WriteExceptionsToEventLog = false;
        private string _ApplicationName;
        private long _AppID;

        private bool _initialized = false;

    <Reference Include="System.configuration" />
    <Reference Include="System.Data" />
    <Reference Include="System.Data.SQLite" />
    <Reference Include="System.Web" />
    <Reference Include="System.Xml" />
  </ItemGroup>
  <ItemGroup>

    <Compile Include="Properties\Settings.Designer.cs">
      <AutoGen>True</AutoGen>
      <DesignTimeSharedInput>True</DesignTimeSharedInput>
      <DependentUpon>Settings.settings</DependentUpon>
    </Compile>
    <Compile Include="SiteMap\DynamicSiteMap.cs" />
    <Compile Include="SiteMap\StaticSiteMap.cs" />

Create Table SiteMapNodeRoles(
	NodeID integer NOT NULL,
	RoleID integer NOT NULL,
	AppID integer NOT NULL
);


--Create Table Profile(
--	ProfileID INTEGER PRIMARY KEY,
--	UserID integer NOT NULL,
--	AppID integer NOT NULL,
--	LastUpdatedDate Datetime,
--	LastActivityDate Datetime
--);
--
--Create Table ProfileData(
--	ItemID INTEGER PRIMARY KEY,
--	ProfileID integer NOT NULL,
--	ItemData BLOB,
--	ItemName text NOT NULL,
--	ItemFormat text NOT NULL
--);
--
--
-- -- Views
--Create View UserProfile As 
--Select Profile.ProfileID as ProfileID, User.UserName as UserName, Profile.LastActivityDate as LastActivityDate, Profile.LastUpdatedDate as LastUpdatedDate, User.AppID as AppID from Profile
--Inner Join User On Profile.UserID = User.UserID and Profile.AppID = User.AppID;