System.Data.SQLite

Check-in [b0f8d0fe4e]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Add more testing of the SQLiteConnection.ChangePassword method.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: b0f8d0fe4ee277f0cca1d802c66bf315cdb88d97
User & Date: mistachkin 2011-10-23 02:32:26.715
Context
2011-10-23
02:33
Add the external tools needed to build the documentation. check-in: 418f5dab8c user: mistachkin tags: trunk
02:32
Add more testing of the SQLiteConnection.ChangePassword method. check-in: b0f8d0fe4e user: mistachkin tags: trunk
2011-10-20
14:04
Compile error fixes for the Compact Framework. Also, switch to using the .NET Framework 4.0 Client Profile where applicable. Fix for ticket [566f1ad1e4]. check-in: f2b84d6d25 user: mistachkin tags: trunk
Changes
Unified Diff Ignore Whitespace Patch
Changes to test/TestCases.cs.
107
108
109
110
111
112
113






















114
115
116
117
118
119
120
            cnn.SetPassword("mypassword");
            cnn.Open();

            // Decrpyt database
            cnn.ChangePassword("");

            cnn.Close();























            // Try opening now without password
            cnn.Open();
            cnn.Close();

        }
    }







>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>







107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
            cnn.SetPassword("mypassword");
            cnn.Open();

            // Decrpyt database
            cnn.ChangePassword("");

            cnn.Close();

            ///////////////////////////////////////////////////////////////////

            cnn.Open();

            // Re-Encrypts the database. The connection remains valid and usable afterwards.
            cnn.ChangePassword("mypassword");
            cnn.ChangePassword("mynewerpassword");

            maydroptable.Add("ChangePasswordTest2");
            if (cnn.State != ConnectionState.Open) cnn.Open();
            using (DbCommand cmd = cnn.CreateCommand())
            {
                cmd.CommandText = "CREATE TABLE ChangePasswordTest2(ID int primary key)";
                cmd.ExecuteNonQuery();
            }

            // Decrpyt database
            cnn.ChangePassword("");
            cnn.Close();

            ///////////////////////////////////////////////////////////////////

            // Try opening now without password
            cnn.Open();
            cnn.Close();

        }
    }