如何从任何视图控制器全局访问sql db

本文关键字:全局 访问 sql db 控制器 视图 任何 | 更新日期: 2023-09-27 18:19:22

public class MedicineTransation{
[PrimaryKey, AutoIncrement]
public int   Id { get; set; }
public string name {get;set;}
public int age {get;set;}
public string grade {get;set;}
}               
// StudentViewController
//Add student Record to student database.  
btn_AddRecord.TouchUpInside += ((object sender, EventArgs e) => { 
    string folder = Environment.GetFolderPath (Environment.SpecialFolder.Personal);
    var db = new SQLiteConnection (System.IO.Path.Combine (folder, "student.db"));
    db.CreateTable<MedicineTransation>();
    var student = new Student { 
    name = studentName;
    age = studentage;
    grade = studentGrade;
    };
  db.Insert (student);
)};
//DetailedViewController
//Delete student Record to student database.  
   btn_DeleteRecord.TouchUpInside += ((object sender, EventArgs e) => { 
//  db.Insert (student); Insert Record into database.
//  db.Delete (student); Delete Record from database.
}

想从另一个视图控制器访问相同的数据库

如何从任何视图控制器全局访问sql db

您可以实现存储库模式。

http://msdn.microsoft.com/en-us/library/ff649690.aspx

或者(如果这种模式有些过分),那么您可以创建一个模型类,并让它通过静态方法或单独的单例来管理自己。