Esempi in C# (CSharp) per DatabaseObjects.SQL.SQLDelete

Esempio n. 1

File: SQLiteConnectionTests.cs Progetto: erdincay/DatabaseObjects-UnitTests

        public void RepeatedlyInsertDelete()
        {
            var insert = new DatabaseObjects.SQL.SQLInsert();
            insert.TableName = "T1";
            insert.Fields.Add("Name", "ABC123");

            var delete = new DatabaseObjects.SQL.SQLDelete("T1");

            for (int i = 0; i < 10000; i++)
            {
                using (var connectionScope = new DatabaseObjects.ConnectionScope(database))
                {
                    connectionScope.ExecuteNonQuery(insert);
                    connectionScope.ExecuteNonQuery(delete);
                    Debug.WriteLine("Executed {0} times", (i + 1));
                }
            }
        }

Esempio n. 2

        public void RepeatedlyInsertDelete()
        {
            var insert = new DatabaseObjects.SQL.SQLInsert();

            insert.TableName = "T1";
            insert.Fields.Add("Name", "ABC123");

            var delete = new DatabaseObjects.SQL.SQLDelete("T1");

            for (int i = 0; i < 10000; i++)
            {
                using (var connectionScope = new DatabaseObjects.ConnectionScope(database))
                {
                    connectionScope.ExecuteNonQuery(insert);
                    connectionScope.ExecuteNonQuery(delete);
                    Debug.WriteLine("Executed {0} times", (i + 1));
                }
            }
        }