public void TestBasicCRUD() { using (Model.Context db = new Model.Context("mdbConnectionString")) { Note n = new Note(); n.Content = "Test content"; n.Created = DateTime.UtcNow.Date; n.Modified = DateTime.UtcNow.Date; db.InsertOnSubmit <Note>(n); db.SubmitChanges(); Assert.AreNotEqual(n.Codigo, 0); Note result = db.Connection.Query <Note>("SELECT * FROM Notes WHERE Codigo = @Id", new { Id = n.Codigo }).FirstOrDefault(); Assert.AreNotEqual(result, null); Assert.AreEqual(result.Content, n.Content); Assert.AreEqual(result.Created, n.Created); Assert.AreEqual(result.Modified, n.Modified); db.DeleteOnSubmit <Note>(result); db.SubmitChanges(); Assert.IsFalse(db.Connection.Query <Post>("SELECT * FROM Notes WHERE Codigo = @Id", new { Id = n.Codigo }).Any()); } }
public void TestBasicCRUD() { using (Model.Context db = new Model.Context("mdbConnectionString")) { Note n = new Note(); n.Content = "Test content"; n.Created = DateTime.UtcNow.Date; n.Modified = DateTime.UtcNow.Date; db.InsertOnSubmit<Note>(n); db.SubmitChanges(); Assert.AreNotEqual(n.Codigo, 0); Note result = db.Connection.Query<Note>("SELECT * FROM Notes WHERE Codigo = @Id", new { Id = n.Codigo }).FirstOrDefault(); Assert.AreNotEqual(result, null); Assert.AreEqual(result.Content, n.Content); Assert.AreEqual(result.Created, n.Created); Assert.AreEqual(result.Modified, n.Modified); db.DeleteOnSubmit<Note>(result); db.SubmitChanges(); Assert.IsFalse(db.Connection.Query<Post>("SELECT * FROM Notes WHERE Codigo = @Id", new { Id = n.Codigo }).Any()); } }
public void TestUpdateCollection() { using (Model.Context db = new Model.Context("mdbConnectionString")) { Author a = new Author(); a.Username = "******"; a.Posts = new List <Post>(); Post p = new Post(); p.Content = "Test post content"; Post pp = new Post(); pp.Content = "Another test content"; a.Posts.Add(p); a.Posts.Add(pp); db.InsertOnSubmit <Author>(a); // assume it works, tested on other methods db.SubmitChanges(); a.Posts.First().Content = "Last content"; db.UpdateOnSubmit <Author>(a, Context.CascadeStyle.All); db.SubmitChanges(); Post compare = db.Connection.Query <Post>("SELECT * FROM Posts WHERE Id = " + a.Posts.First().Id).FirstOrDefault(); Assert.AreEqual(compare.Content, a.Posts.First().Content); db.DeleteOnSubmit <Author>(a, Context.CascadeStyle.All); db.SubmitChanges(); } }
public void TestChainedInsertSimple() { using (Model.Context db = new Model.Context("mdbConnectionString")) { Author a = new Author(); a.Username = "******"; Post p = new Post(); p.Content = "Test content"; p.Author = a; int id = db.InsertOnSubmit <Post>(p); Assert.AreEqual(id, p.Id); Assert.AreEqual(p.Author, a); Assert.AreNotEqual(p.Author.Id, 0); db.DeleteOnSubmit <Post>(p, Context.CascadeStyle.Single); // force cascading delete db.SubmitChanges(); } }
public void TestChainedInsertUsingCollection() { using (Model.Context db = new Model.Context("mdbConnectionString")) { Post p = new Post(); p.Content = "Test content 'n' escapes!"; Author a = new Author(); a.Username = "******"; a.Posts = new List <Post>(); a.Posts.Add(p); int id = db.InsertOnSubmit <Author>(a); Assert.AreEqual(a.Id, id); Assert.AreEqual(a.Posts.First(), p); db.DeleteOnSubmit <Author>(a, Context.CascadeStyle.Collection); // force cascading delete db.SubmitChanges(); } }
public void TestChainedInsertSimple() { using (Model.Context db = new Model.Context("mdbConnectionString")) { Author a = new Author(); a.Username = "******"; Post p = new Post(); p.Content = "Test content"; p.Author = a; int id = db.InsertOnSubmit<Post>(p); Assert.AreEqual(id, p.Id); Assert.AreEqual(p.Author, a); Assert.AreNotEqual(p.Author.Id, 0); db.DeleteOnSubmit<Post>(p, Context.CascadeStyle.Single); // force cascading delete db.SubmitChanges(); } }
public void TestUpdateSimple() { using (Model.Context db = new Model.Context("mdbConnectionString")) { Note n = new Note(); n.Content = "Prueba"; n.Created = DateTime.UtcNow.Date; n.Modified = DateTime.UtcNow.Date; db.InsertOnSubmit <Note>(n); db.SubmitChanges(); n.Content = "Test"; db.UpdateOnSubmit <Note>(n); db.SubmitChanges(); Note newNote = db.Connection.Query <Note>("SELECT * FROM Notes WHERE Codigo = " + n.Codigo).FirstOrDefault(); Assert.AreEqual(newNote.Content, "Test"); db.DeleteOnSubmit <Note>(newNote); db.SubmitChanges(); } }
public void TestChainedInsertUsingCollection() { using (Model.Context db = new Model.Context("mdbConnectionString")) { Post p = new Post(); p.Content = "Test content 'n' escapes!"; Author a = new Author(); a.Username = "******"; a.Posts = new List<Post>(); a.Posts.Add(p); int id = db.InsertOnSubmit<Author>(a); Assert.AreEqual(a.Id, id); Assert.AreEqual(a.Posts.First(), p); db.DeleteOnSubmit<Author>(a, Context.CascadeStyle.Collection); // force cascading delete db.SubmitChanges(); } }
public void TestUpdateSimple() { using (Model.Context db = new Model.Context("mdbConnectionString")) { Note n = new Note(); n.Content = "Prueba"; n.Created = DateTime.UtcNow.Date; n.Modified = DateTime.UtcNow.Date; db.InsertOnSubmit<Note>(n); db.SubmitChanges(); n.Content = "Test"; db.UpdateOnSubmit<Note>(n); db.SubmitChanges(); Note newNote = db.Connection.Query<Note>("SELECT * FROM Notes WHERE Codigo = " + n.Codigo).FirstOrDefault(); Assert.AreEqual(newNote.Content, "Test"); db.DeleteOnSubmit<Note>(newNote); db.SubmitChanges(); } }
public void TestUpdateCollection() { using (Model.Context db = new Model.Context("mdbConnectionString")) { Author a = new Author(); a.Username = "******"; a.Posts = new List<Post>(); Post p = new Post(); p.Content = "Test post content"; Post pp = new Post(); pp.Content = "Another test content"; a.Posts.Add(p); a.Posts.Add(pp); db.InsertOnSubmit<Author>(a); // assume it works, tested on other methods db.SubmitChanges(); a.Posts.First().Content = "Last content"; db.UpdateOnSubmit<Author>(a, Context.CascadeStyle.All); db.SubmitChanges(); Post compare = db.Connection.Query<Post>("SELECT * FROM Posts WHERE Id = " + a.Posts.First().Id).FirstOrDefault(); Assert.AreEqual(compare.Content, a.Posts.First().Content); db.DeleteOnSubmit<Author>(a, Context.CascadeStyle.All); db.SubmitChanges(); } }