C# (CSharp) SQLiteRepository.ExecuteSql Exemples

Exemple #1

Fichier : SQLiteTests.cs Projet : 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);
    }

Exemple #2

Fichier : SQLiteTests.cs Projet : 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);
 }