如何使用monotouch以编程方式在sqlite中创建数据库和表? [英] How to create database and table in sqlite programatically using monotouch?

问题描述

任何机构都可以帮助我，如何使用monotouch在sqlite中以编程方式创建简单的数据库和表并插入值，一步一步的过程.我是这项技术的新手.谢谢..

Can any body help me about, how to create simple database and tables programatically and insert values ,step by step procedure in sqlite using monotouch.I am new to this technology . Thank you..

推荐答案

如果您使用的是 sqlite-net(我强烈推荐)你可以简单地调用:

If you're using sqlite-net (which I highly recommend) you can simply call:

public class Stock
{
        [PrimaryKey, AutoIncrement]
        public int Id { get; set; }
        [MaxLength(8)]
        public string Symbol { get; set; }
}

创建

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

插入

var s = db.Insert(new Stock() {
Symbol = symbol });

查询

return db.Query("select * from Valuation where StockId = ?", stock.Id);

Query

return db.Query ("select * from Valuation where StockId = ?", stock.Id);

这篇关于如何使用monotouch以编程方式在sqlite中创建数据库和表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！