Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using ServiceStack;
- using ServiceStack.Text;
- using ServiceStack.OrmLite;
- using ServiceStack.OrmLite.Sqlite;
- using ServiceStack.DataAnnotations;
- using ServiceStack.Model;
- var dbFactory = new OrmLiteConnectionFactory(":memory:", SqliteDialect.Provider);
- var db = dbFactory.Open(); // Open ADO.NET DB Connection
- public partial class Users : IHasId<int>
- {
- [AutoIncrement]
- public int Id { get; set; }
- [Required]
- public string Email { get; set; }
- [Required]
- public string Password { get; set; }
- [References(typeof(Roles))]
- [Required]
- public int RolesId { get; set; }
- [Reference]
- public Roles Roles { get; set; }
- }
- public partial class Roles : IHasId<int>
- {
- [AutoIncrement]
- public int Id { get; set; }
- [Required]
- public string Name { get; set; }
- }
- db.CreateTable<Roles>();
- db.CreateTable<Users>();
- db.Insert(new Roles { Name = "Role 1" });
- db.Insert(new Roles { Name = "Role 2" });
- db.Insert(new Users { Email = "user1@gmail.com", Password = "test", RolesId = 1 });
- db.Insert(new Users { Email = "user2@gmail.com", Password = "test", RolesId = 1 });
- db.Insert(new Users { Email = "user3@gmail.com", Password = "test", RolesId = 2 });
- var user1 = db.LoadSelect<Users>(x => x.Id == 1);
- user1.PrintDump();
Add Comment
Please, Sign In to add comment