Пример #1
0
        private void button2_Click(object sender, EventArgs e)
        {
            var foo = new foo();
            foo.name = "Insert Test";

            using (var session = GetFactory().OpenSession())
            {
                using (var transaction = session.BeginTransaction())
                {
                    session.Insert(foo);
                    transaction.Commit();
                    // foo.Id will now be set to the value generated by the database when the record was inserted.
                }
            }
        }
Пример #2
0
        private void button2_Click(object sender, EventArgs e)
        {
            // Create a PetaPoco database object
            var db = new PetaPoco.Database("sqlite");
            foo foo = new foo();
            foo.name = "PetaPoco Insert Test";

            try
            {
                db.Insert("foo", "Id", foo);
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message + Environment.NewLine + ex.StackTrace);
            }
            this.fooQuery1.Refresh();
        }
Пример #3
0
        private void button2_Click(object sender, EventArgs e)
        {
            foo foo = new foo();
            foo.name = "Created by Dapper";

            using (SQLiteConnection conn = GetSqlConnection())
            {
                conn.Open();

                string sqlQuery = "INSERT INTO foo(name) VALUES (@name)";
                conn.Execute(sqlQuery,
                    new
                    {
                        name="Created by Dapper"//foo.name
                    });

                conn.Close();
            }

            this.fooQuery1.Refresh();
        }
Пример #4
0
        private void DoBackgroundWork_Insert(object sender, System.ComponentModel.DoWorkEventArgs e)
        {
            BackgroundWorker worker = sender as BackgroundWorker;

            using (var session = GetFactory().OpenSession())
            {
                using (var transaction = session.BeginTransaction())
                {
                    for (int i = 0; i < count; i++)
                    {
                        var foo = new foo();
                        foo.name = "MicroLite Insert Test " + i;
                        session.Insert(foo);
                        if (i % 500 == 0) worker.ReportProgress(i);//this.fooQuery1.AppendDisplay(".");
                    }
                    transaction.Commit();
                }
            }
        }
Пример #5
0
        private void DoBackgroundWork_Insert(object sender, System.ComponentModel.DoWorkEventArgs e)
        {
            BackgroundWorker worker = sender as BackgroundWorker;

            // Create a PetaPoco database object
            var db = new PetaPoco.Database("sqlite");
            using (var transaction = db.GetTransaction())
            {
                for (int i = 0; i < count; i++)
                {
                    foo foo = new foo();
                    foo.name = "PetaPoco Insert Test " + i;
                    db.Insert("foo", "Id", foo);

                    if (i % 500 == 0) worker.ReportProgress(i);//this.fooQuery1.AppendDisplay(".");

                }
                transaction.Complete();
            }
        }