如何使用monotouch以编程方式在sqlite中创建数据库和表?
任何机构都可以帮助我,如何使用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);
相关文章