Advertisement
Guest User

Untitled

a guest
Jun 20th, 2019
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.87 KB | None | 0 0
  1. public class App : Application
  2. {
  3. public override void OnCreate()
  4. {
  5. base.OnCreate();
  6.  
  7. string libraryPath = System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal);
  8. string sqliteFilename = "db.db3";
  9.  
  10. string path = Path.Combine(libraryPath, sqliteFilename);
  11. conn = new SQLiteConnection(path);
  12. }
  13. }
  14.  
  15. public class Database
  16. {
  17. readonly object locker = new object();
  18. SQLiteConnection database;
  19.  
  20. public Database(SQLiteConnection conn)
  21. {
  22. database = conn;
  23.  
  24. database.CreateTable<Tabla1>();
  25. database.CreateTable<Tabla2>();
  26. }
  27.  
  28. public IEnumerable<Tabla1> GetDatos()
  29. {
  30. lock (locker)
  31. {
  32. return (from i in database.Table<Tabla1>()
  33. orderby i.Titulo ascending
  34. select i).ToList();
  35. }
  36. }
  37.  
  38. //Etcétera.
  39. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement