Code doesn't throw error but data not added

Question

I have a form that allows user to update and also create new entries to database, I am able to update but not create. The following is dal

if (actionrequired == Crud.Modify)
{
                    t_ProvisionSetup setupToBeChanged = (from p in Entities.t_ProvisionSetup
                                                         where p.ProvisionSetupId == provision.ProvisionSetupId
                                                         select p).Single();
                    setupToBeChanged.ModifiedOn = DateTime.UtcNow;
                    setupToBeChanged.ModifiedBy = userId;
                    setupToBeChanged = MapSetupToEntity(provision, setupToBeChanged);
                    Entities.SaveChanges();
                    setupid = setupToBeChanged.ProvisionSetupId;
}

if (actionrequired == Crud.Add)
{
                    t_ProvisionSetup setupToBeChanged = new t_ProvisionSetup();
                    setupToBeChanged = MapSetupToEntity(provision, setupToBeChanged);
                    setupToBeChanged.ModifiedBy = userId;
                    setupToBeChanged.ModifiedOn = DateTime.UtcNow;
                    setupToBeChanged.CreatedBy = userId;
                    setupToBeChanged.CreatedOn = DateTime.UtcNow;

                    Entities.SaveChanges();
                    setupid = setupToBeChanged.ProvisionSetupId;
}

It runs fine no errors but won't create new record.

Tyler Wilson · Accepted Answer · 2013-05-16 00:01:52Z

2

Possibly you need something like this?

Entities.t_ProvisionSetup.Add(setupToBeChanged);

before calling Entities.SaveChanges().

answered May 16, 2013 at 0:01

Tyler Wilson

5965 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Code doesn't throw error but data not added

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related