DevForce Community Forum : update & delete problem http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : update & delete problem Wed, 15 Apr 2026 19:58:50 -700 Tue, 12 Jun 2012 10:18:16 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=3491 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ update & delete problem : rasel,In the earlier post... http://www.ideablade.com/forum/forum_posts.asp?TID=3491&PID=13821#13821 Author: sbelini
Subject: 3491
Posted: 12-Jun-2012 at 10:18am

rasel,
 
In the earlier post you were actually creating 2 entities with the same ID. (i.e. not modifying the entity the second time around)
In that case, you will get a save exception. (unless the IDs are being resolved at the datasource level)
 
If you want to modify an entity, it must exist in the datasource first. So you'd need to retrieve it, make the changes, and then save back to the datasource:
 
var testEm = new boolEntities(compositionContextName: CompositionContext.Fake.Name);
var testProducts = new Product[] {
new Product {ProductID = 0, Name = "test", Description = "tesr", Price = 12, Category = "test"} };
testEm.AddEntities(testProducts);
testEm.SaveChanges();
testEm.Clear();
var prod = testEm.Products.FirstOrDefault(p => p.ProductID == prod.ProductID);
 
prod.Description = "test";
 
SaveResult sr = testEm.SaveChanges(new Product[] {prod});
 
I suggest you visit our DevForce Resource Center. There you will have access to several articles and samples that will help better understand how DevForce works.
 
Regards,
   Silvio.
]]> Tue, 12 Jun 2012 10:18:16 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3491&PID=13821#13821 update & delete problem : I found the solution: // Act -... http://www.ideablade.com/forum/forum_posts.asp?TID=3491&PID=13817#13817 Author: rasel
Subject: 3491
Posted: 11-Jun-2012 at 11:26pm

I found the solution:

            // Act - update the product
            testEm.AttachEntity(prod, EntityState.Modified);
            SaveResult sr = testEm.SaveChanges();

]]> Mon, 11 Jun 2012 23:26:47 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3491&PID=13817#13817 update & delete problem : Hello sbelini,Thank you for the... http://www.ideablade.com/forum/forum_posts.asp?TID=3491&PID=13816#13816 Author: rasel
Subject: 3491
Posted: 11-Jun-2012 at 9:43pm

Hello sbelini,

Thank you for the fast reply. I also found the EntityAspect.Delete method after I posted my message. How about update? What is wrong with my below code?

            // Arrange
            var testEm = new boolEntities(compositionContextName: CompositionContext.Fake.Name);
            var testProducts = new Product[] {
            new Product {ProductID = 0, Name = "test", Description = "tesr", Price = 12, Category = "test"} };
            testEm.AddEntities(testProducts);
            testEm.SaveChanges();
            testEm.Clear();

            Product prod = new Product { ProductID = 0, Name = "test", Description = "test", Price = 12, Category = "test" };

            // Act - update the product
            SaveResult sr = testEm.SaveChanges(new Product[] {prod});

            // Assert
            Product pp = testEm.Products.FirstOrDefault(p => p.ProductID == prod.ProductID);
            Assert.IsTrue(pp.Description.Equals("test"));

]]> Mon, 11 Jun 2012 21:43:05 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3491&PID=13816#13816 update & delete problem : Hi rasel,To delete an entity... http://www.ideablade.com/forum/forum_posts.asp?TID=3491&PID=13813#13813 Author: sbelini
Subject: 3491
Posted: 11-Jun-2012 at 12:23pm

Hi rasel,
 
To delete an entity you should use myEntity.EntityAspect.Delete().
 
You can find details about the Delete method and RemoveEntity method in our API documentation.
 
Regards,
   Silvio.
]]> Mon, 11 Jun 2012 12:23:45 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3491&PID=13813#13813 update & delete problem : Hello,I'm trying Devforce... http://www.ideablade.com/forum/forum_posts.asp?TID=3491&PID=13812#13812 Author: rasel
Subject: 3491
Posted: 11-Jun-2012 at 11:15am

Hello,

I'm trying Devforce with a sample application. I can read from sqlite DB and add records to it but can't update or delete db. I wrote a sample unit test to simulate my delete routine. This test fails and saveresult status is OK-NoOperation. What is wrong with my code?

            // Arrange
            var testEm = new boolEntities(compositionContextName: CompositionContext.Fake.Name);
            var testProducts = new Product[] {
            new Product {ProductID = 0, Name = "test", Description = "test", Price = 12, Category = "test"} };
            testEm.AddEntities(testProducts);
            testEm.SaveChanges();
            testEm.Clear();

            Product prod = new Product { ProductID = 0, Name = "test", Description = "test", Price = 12, Category = "test" };

            // Act - delete the product
            testEm.Products.EntityManager.RemoveEntity(prod);
            SaveResult sr = testEm.SaveChanges();

            // Assert
            int ct = testEm.Products.Count();
            Assert.IsTrue(ct == 0);


]]> Mon, 11 Jun 2012 11:15:01 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3491&PID=13812#13812