1. Home
  2. LLBLGen Pro
  3. LLBLGen Pro Runtime Framework

Best way to update multiple records with LLBL when Stored Procedures are not an option?

Posts   
 
    
Joe_PR
User
Posts: 3
Joined: 02-Dec-2008
# Posted on: 02-Dec-2008 18:50:17   

Microsoft SQL CE does not support Stored Procedures. I want to execute a simple SQL statement 

Update TableA Set x=1 where y=2

Can this be done using LLBLGen (I would like to do it using LLBLGen because we are going to use other databases in the future) or should I issue the statement manually using a .Net SqlCe command object? Thank you very much!

DvK
User
Posts: 318
Joined: 22-Mar-2006
# Posted on: 02-Dec-2008 20:48:17   

Use a UpdateEntitiesDirectly from the Adapter model to get this done...

MTrinder
User
Posts: 1461
Joined: 08-Oct-2008
# Posted on: 02-Dec-2008 21:24:18   

The documentation for this is here

See option 3

Matt