C# SQLiteConnection.Insert方法代码示例

		private SQLiteConnection GetDatabaseConnection() {
			var documents = Environment.GetFolderPath (Environment.SpecialFolder.Desktop);
			string db = Path.Combine (documents, "Occupation.db3");
			OccupationModel Occupation;

			// Create the database if it doesn't already exist
			bool exists = File.Exists (db);

			// Create connection to database
			var conn = new SQLiteConnection (db);

			// Initially populate table?
			if (!exists) {
				// Yes, build table
				conn.CreateTable<OccupationModel> ();

				// Add occupations
				Occupation = new OccupationModel ("Documentation Manager", "Manages the Documentation Group");
				conn.Insert (Occupation);

				Occupation = new OccupationModel ("Technical Writer", "Writes technical documentation and sample applications");
				conn.Insert (Occupation);

				Occupation = new OccupationModel ("Web & Infrastructure", "Creates and maintains the websites that drive documentation");
				conn.Insert (Occupation);

				Occupation = new OccupationModel ("API Documentation Manager", "Manages the API Doucmentation Group");
				conn.Insert (Occupation);

				Occupation = new OccupationModel ("API Documentor", "Creates and maintains API documentation");
				conn.Insert (Occupation);
			}

			return conn;
		}

		/// <returns>
		/// Output of test query
		/// </returns>
		public static string DoSomeDataAccess ()
		{
			var output = "";
			output += "\nCreating database, if it doesn't already exist";
			string dbPath = Path.Combine (
				Environment.GetFolderPath (Environment.SpecialFolder.Personal), "ormdemo.db3");

			var db = new SQLiteConnection (dbPath);
			db.CreateTable<Stock> ();

			if (db.Table<Stock> ().Count() == 0) {
				// only insert the data if it doesn't already exist
				var newStock = new Stock ();
				newStock.Symbol = "AAPL";
				db.Insert (newStock); 

				newStock = new Stock ();
				newStock.Symbol = "GOOG";
				db.Insert (newStock); 

				newStock = new Stock ();
				newStock.Symbol = "MSFT";
				db.Insert (newStock);
			}

			output += "\nReading data using Orm";
			var table = db.Table<Stock> ();
			foreach (var s in table) {
				output += "\n" + s.Id + " " + s.Symbol;
			}

			return output;
		}

        private static void KyPowerball(SQLiteConnection connection)
        {
            string path = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location);
            path = Path.Combine(path, "Powerball.txt");

            using (var stream = File.OpenRead(path))
            {
                using (var reader = new StreamReader(stream))
                {
                    while (!reader.EndOfStream)
                    {
                        string line = reader.ReadLine();
                        var split = line.Split('\t');

                        var win = new Win
                        {
                            Date = DateTime.Parse(split[0]),
                        };
                        connection.Insert(win);

                        var numbers = split[1].Split('–');
                        for (int i = 0; i < numbers.Length; i++)
                        {
                            connection.Insert(new Numbers
                            {
                                Number = int.Parse(numbers[i].Trim()),
                                Win = win.ID,
                                MegaBall = i == 5,
                            });
                        }
                    }
                }
            }
        }

        public TradeTable(SQLiteConnection database, TradeInstance trade)
        {
            var tradeClient0 = new TradeClient(database, trade.Client0Id, trade.Client0Monster);
            database.Insert(tradeClient0);
            TradeClient0Id = tradeClient0.Id;

            var tradeClient1 = new TradeClient(database, trade.Client1Id, trade.Client1Monster);
            database.Insert(tradeClient1);
            TradeClient1Id = tradeClient1.Id;
        }

        public static void Save(IEnumerable<Country> countryList, string connectionString)
        {
            if (countryList == null)
                throw new ArgumentNullException("countryList");

            using (SQLiteConnection connection = new SQLiteConnection(connectionString))
            {
                foreach (Country country in countryList)
                {
                    CountryDataObject countryDataObject = new CountryDataObject
                    {
                        name = country.Name,
                        is_important = country.IsHot ? 1 : 0
                    };

                    connection.Insert(countryDataObject);

                    foreach (Location location1 in country.Locations)
                    {
                        LocationDataObject location1DataObject = GetLocationDataObject(
                            location: location1,
                            parent_id: null,
                            country_id: countryDataObject.id);

                        connection.Insert(location1DataObject);

                        foreach (Location location2 in location1.Locations)
                        {
                            LocationDataObject location2DataObject = GetLocationDataObject(
                                location: location2,
                                parent_id: location1DataObject.id,
                                country_id: countryDataObject.id);

                            connection.Insert(location2DataObject);

                            foreach (Location location3 in location2.Locations)
                            {
                                LocationDataObject location3DataObject = GetLocationDataObject(
                                    location: location3,
                                    parent_id: location2DataObject.id,
                                    country_id: countryDataObject.id);

                                connection.Insert(location3DataObject);
                            }
                        }
                    }
                }
            }
        }

        public string CreateAccount(double _sum, String _name)
        {
            string res = "1;1";
            var dbPath = Path.Combine(ApplicationData.Current.LocalFolder.Path, dbname);
            using (var db = new SQLiteConnection(dbPath))
            {
                // Работа с БД
                var _acc = new AccountTable() { _Name = _name, CurrentMoneyAmount = _sum };
                db.Insert(_acc);
                var _change = new ChangesTable() { _DBString = "INSERT INTO AccountTable(_Name, CurrentMoneyAmount) VALUES('" + _name + "', '" + _sum + "');", _ChangesDatetime = DateTime.Now };
                db.Insert(_change);
            }

            return res;
        }

 public void Insert(Chinese chinese)
 {
     using (var db = new SQLiteConnection(dbPath))
     {
         db.RunInTransaction(() => db.Insert(chinese));
     }
 }

        async Task RunCreateTest()
        {
            await Task.Factory.StartNew(() =>
            {
                using (var db = new SQLiteConnection(DatabasePath))
                {
                    db.CreateTable<Person>();
                    db.RunInTransaction(() =>
                    {
                        for (var i = 0; i < 10; i++)
                            db.Insert(new Person { FullName = "Person " + i });
                    });

                    var count = 0;
                    db.RunInTransaction(() =>
                    {
                        var table = db.Table<Person>();
                        count = table.Count();
                    });

                    var message = count == 10
                                ? "Completed!"
                                : string.Format("Only inserted {0} rows!", count);

                    dispatcher.RunIdleAsync(o => { CreateResult = message; });
                }

                
            });
        }

 public static void InsertLocation(Location Location)
 {
     using (var db = new SQLiteConnection(DatabasePath))
     {
         db.Insert(Location);
     }
 }

 public void InsertLog(Log log)
 {
     using (var connection = new SQLiteConnection(_dbPath) { Trace = true })
     {
         connection.Insert(log);
     }
 }

 public void InsertOffender(Offender offender)
 {
     using (var connection = new SQLiteConnection(_dbPath) { Trace = true })
     {
         connection.Insert(offender);
     }
 }

partial         void btnAdd_TouchUpInside(UIButton sender)
        {
            // Input Validation: only insert a book if the title is not empty
            if (!string.IsNullOrEmpty(txtTitle.Text))
            {
                // Insert a new book into the database
                var newBook = new Book { BookTitle = txtTitle.Text, ISBN = txtISBN.Text };

                var db = new SQLiteConnection (filePath);
                db.Insert (newBook);

                // TODO: Add code to populate the Table View with the new values

                // show an alert to confirm that the book has been added
                new UIAlertView(
                    "Success",
                    string.Format("Book ID: {0} with Title: {1} has been successfully added!", newBook.BookId, newBook.BookTitle),
                    null,
                    "OK").Show();

                PopulateTableView();

                // call this method to refresh the Table View data
                tblBooks.ReloadData ();
            }
            else
            {
                new UIAlertView("Failed", "Enter a valid Book Title",null,"OK").Show();
            }
        }

		private static void AddStocksToDb(SQLiteConnection db, string symbol, string name, string file)
		{
			// parse the stock csv file
			const int NUMBER_OF_FIELDS = 7;    // The text file will have 7 fields, The first is the date, the last is the adjusted closing price
			TextParser parser = new TextParser(",", NUMBER_OF_FIELDS);     // instantiate our general purpose text file parser object.
			List<string[]> stringArrays;    // The parser generates a List of string arrays. Each array represents one line of the text file.
			stringArrays = parser.ParseText(File.Open(@"../../../DataAccess-Console/DAL/" + file,FileMode.Open));     // Open the file as a stream and parse all the text

			// Don't use the first array, it's a header
			stringArrays.RemoveAt(0);
			// Copy the List of strings into our Database
			int pk = 0;
			foreach (string[] stockInfo in stringArrays) {
				pk += db.Insert (new Stock () {
					Symbol = symbol,
					Name = name,
					Date = Convert.ToDateTime (stockInfo [0]),
					ClosingPrice = decimal.Parse (stockInfo [6])
				});
				// Give an update every 100 rows
				if (pk % 100 == 0)
					Console.WriteLine ("{0} {1} rows inserted", pk, symbol);
			}
			// Show the final count of rows inserted
			Console.WriteLine ("{0} {1} rows inserted", pk, symbol);			
		}

 public void Add(Account acc)
 {
     using (var connection = new SQLiteConnection(_dbPath))
     {
         connection.Insert(acc);
     }
 }

        protected override void OnCreate(Bundle bundle)
        {
            base.OnCreate (bundle);
            SetContentView (Resource.Layout.gmail);

            // Create your application here
            EditText ed1 = FindViewById<EditText> (Resource.Id.editText1);
            EditText ed2 = FindViewById<EditText> (Resource.Id.editText2);
            Button save = FindViewById<Button> (Resource.Id.save);
            save.Click += delegate {
                string path = System.Environment.GetFolderPath (System.Environment.SpecialFolder.Personal);
                SQLiteConnection dbConn = new SQLiteConnection (System.IO.Path.Combine (path, DbName));

                dbConn.CreateTable<Mail> ();
                // only insert the data if it doesn't already exist
                Mail newRw = new Mail ();
                newRw.mailId = ed1.Text;
                newRw.password = ed2.Text;
                dbConn.Insert (newRw);
                Toast toast = Toast.MakeText(this, "Sucessful", ToastLength.Long);
                toast.Show();
                StartActivity(typeof(MainActivity));
                Finish();

            };
        }