本文整理汇总了C#中Microsoft.Data.Sqlite.SqliteConnection.Dispose方法的典型用法代码示例。如果您正苦于以下问题:C# SqliteConnection.Dispose方法的具体用法?C# SqliteConnection.Dispose怎么用?C# SqliteConnection.Dispose使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Microsoft.Data.Sqlite.SqliteConnection
的用法示例。
在下文中一共展示了SqliteConnection.Dispose方法的3个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: BaseDataSQLite
static BaseDataSQLite()
{
#if DEBUG
_sqliteFile = Paths.DebugSQLitePath;
#else
_sqliteFile = Paths.ReleaseSQLitePath;
#endif
//_connectionString = String.Format("Data Source=:memory:");
//_connectionString = String.Format("Data Source={0};Version=3;Pooling=True;Max Pool Size=100;Synchronous=Normal;Journal Mode=WAL", _sqliteFile);
_connectionString = String.Format("Data Source={0}", _sqliteFile);
if (!File.Exists(_sqliteFile))
{
if (!File.Exists(Paths.SqlPath))
throw new FileNotFoundException("Cannot find SQL file: " + Paths.SqlPath);
else {
// Generate database
var conn = new SqliteConnection(_connectionString);
conn.Open();
var sql = File.ReadAllText(Paths.SqlPath);
conn.Execute(sql);
conn.Dispose();
}
}
}
示例2: Dispose_can_be_called_more_than_once
public void Dispose_can_be_called_more_than_once()
{
var connection = new SqliteConnection("Data Source=:memory:");
connection.Open();
connection.Dispose();
connection.Dispose();
}
示例3: Dispose_closes_connection
public void Dispose_closes_connection()
{
var connection = new SqliteConnection("Data Source=:memory:");
connection.Open();
connection.Dispose();
Assert.Equal(ConnectionState.Closed, connection.State);
}