如何使用monotouch以编程方式在sqlite中创建数据库和表?

2021-09-29 00:00:00 sqlite xamarin.ios

任何机构都可以帮助我，如何使用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);

相关文章