http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2009 : using stored procedure function mapping for updating data Tue, 12 May 2026 19:34:47 -700 Fri, 18 Jun 2010 15:33:06 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1665 http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ http://www.ideablade.com/forum/forum_posts.asp?TID=1665&PID=7357#7357 Author: GregD
Subject: 1665
Posted: 18-Jun-2010 at 3:33pm

DevForce 2010 now support entities backed by stored procedures, as of version 6.0.3.]]> Fri, 18 Jun 2010 15:33:06 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1665&PID=7357#7357 http://www.ideablade.com/forum/forum_posts.asp?TID=1665&PID=6294#6294 Author: IdeaBlade
Subject: 1665
Posted: 04-Mar-2010 at 2:52pm

This is a known issue which we plan to address in a future release. For performance reasons, DevForce only passes changes to the Entity Framework; but to accommodate an update via stored procedure, we'll need to seek out from the EF metadata that this is to be the mechanism, and then in that case change what we pass to EF.

The workaround is to communicate with the database directly using DevForce's AdoHelper class. You can find an example of that in the AllocateMoreIds() method in the NumericIdGenerator.cs (or .vb) file in the DevForce Learning Resources, at

     LearningResources\040_BusObjPersistence\AddingDeleting\Snippets\NumericIdGenerator
]]> Thu, 04 Mar 2010 14:52:04 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1665&PID=6294#6294 http://www.ideablade.com/forum/forum_posts.asp?TID=1665&PID=6276#6276 Author: bebe
Subject: 1665
Posted: 02-Mar-2010 at 8:28am

In my model I'm mapping the update function to a stored procedure.

I assumed updating data via DevForce EntityManager would result in the same update statements as updating the data directly with EF. But it's not.
Have a look at this code and the generated update statements as comments:

            //use EF to update data
            using (var ctx = new Model.testEntities())
            {
                var t1 = ctx.Tests.First();
                t1.Value1 = "new value x";
                ctx.SaveChanges();  // -->   exec [dbo].[procTestUpdate] @ID=1,@value1='new value x',@value2='value2',@valueInt=1,@valueDate='2010-01-01 00:00:00'
            }
            
            //use DevForce to update data
            var manager = DomainModel.DomainModelEntityManager.DefaultManager;           
            var t2 = manager.Tests.First();
            t2.Value1 = "new value y";
            manager.SaveChanges();  // --> exec [dbo].[procTestUpdate] @ID=1,@value1='new value y',@value2=NULL,@valueInt=0,@valueDate='0001-01-01 00:00:00'

In EF all values are passed to the stored procedure, regardless whether their value changed or not. Using DevForce only the values of the changed properties are passed and the others are null or default.

Is it posible to change this behavior? Is there any documentation and best practice about writing update procedures in "devforce style"?


]]> Tue, 02 Mar 2010 08:28:44 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1665&PID=6276#6276