mcs/class/Mono.Data.Sqlite/Test/SqliteExceptionUnitTests.cs

   1 // SqliteExceptionUnitTests.cs - NUnit Test Cases for Mono.Data.Sqlite.SqliteExceptions
   2 //
   3 // Author(s):   Thomas Zoechling <thomas.zoechling@gmx.at>
   4
   5
   6 using System;
   7 using System.Data;
   8 using System.IO;
   9 using System.Text;
  10 using Mono.Data.Sqlite;
  11 using NUnit.Framework;
  12
  13 namespace MonoTests.Mono.Data.Sqlite
  14 {
  15         [TestFixture]
  16         public class SqliteExceptionUnitTests
  17         {
  18                 readonly static string _uri = "SqliteTest.db";
  19                 readonly static string _connectionString = "URI=file://" + _uri + ", version=3";
  20                 static SqliteConnection _conn = new SqliteConnection (_connectionString);
  21
  22                 public SqliteExceptionUnitTests()
  23                 {
  24                 }
  25
  26                 [Test]
  27                 [ExpectedException(typeof(SqliteException))]
  28                 public void WrongSyntax()
  29                 {
  30                         SqliteCommand insertCmd = new SqliteCommand("INSERT INTO t1 VALUES (,')",_conn);
  31                         using(_conn)
  32                         {
  33                                 _conn.Open();
  34                                 int res = insertCmd.ExecuteNonQuery();
  35                                 Assert.AreEqual(res,1);
  36                         }
  37                 }
  38         }
  39 }