C# (CSharp) SQLiteRepository.ExecuteSql示例

示例#1

文件： SQLiteTests.cs 项目： sjorsvling/SqlCeToolbox

    public void TestPragma()
    {
        var     sql    = "pragma table_info(Album);" + Environment.NewLine + "GO";
        DataSet result = null;

        using (IRepository repo = new SQLiteRepository(chinookConnectionString))
        {
            result = repo.ExecuteSql(sql);
        }
        Assert.IsTrue(result.Tables.Count == 1);
    }

示例#2

文件： SQLiteTests.cs 项目： inickvel/SqlCeToolbox

 public void TestPragma()
 {
     var sql = "pragma table_info(Album);" + Environment.NewLine + "GO";
     DataSet result = null;
     using (IRepository repo = new SQLiteRepository(chinookConnectionString))
     {
         result = repo.ExecuteSql(sql);
     }
     Assert.IsTrue(result.Tables.Count == 1);
 }