SQLite Forum

How to ReadUncommitted for c# .net framework 4.5
Login
I'm trying to ReadUncommitted

.Net Framework 4.5
Sqlite 1.0.114.0

Please help me to correct following unit-test
Following unit test failing with error "no such table: Message"
        [TestMethod]
        public void Test_Read_Uncommited()
        {
            var connectionString = $"Data Source ={_dbFile}; Cache = Shared; read_uncommitted = true;";
            using (var firstConnection = new SQLiteConnection(connectionString))
            {
                try
                {
                    firstConnection.Open();                            
                    using (var firstTransaction = firstConnection.BeginTransaction())
                    {
                        string message = "Hello World!";
                        var updateCommand = firstConnection.CreateCommand();
                        updateCommand.CommandText = "CREATE TABLE Message(Text TEXT); ";
                        updateCommand.CommandText += $"INSERT INTO Message ( Text ) VALUES ( '{message}' ); ";
                        updateCommand.ExecuteNonQuery();
                        using (var secondConnection = new SQLiteConnection(connectionString))
                        {
                            try
                            {
                                secondConnection.Open();
                                //using (var secondTransaction = secondConnection.BeginTransaction(System.Data.IsolationLevel.ReadUncommitted))
                                {
                                    var queryCommand = secondConnection.CreateCommand();
                                    queryCommand.CommandText = "SELECT Text FROM Message;";
                                    var messageActual = (string)queryCommand.ExecuteScalar();
                                    Assert.IsTrue(string.CompareOrdinal(message, messageActual) == 0);
                                }
                            }
                            finally
                            {
                                secondConnection.Close();
                            }
                            firstTransaction.Rollback();
                        }
                    }    
                }
                finally
                {
                    firstConnection.Close();
                }         
            }
        }