Inserting Data Into Db By Entity Framework Throwing Errors

Question

I Trying to insert the data into Database By using entity framework but it throwing error following An error occurred while updating the entries. See the inner exception for details.

Code is Here

public int InsertUserData(UserDetail userDetail, BusinessObjects objects)
    {
        try
        {
            UserCredential objCredentials = newPersonEntity.UserCredentials
            .First(cd => cd.UserName == objects.UserName);
            objCredentials.Status = objects.Status;
            newPersonEntity.UserDetails.Add(userDetail);
            int result=newPersonEntity.SaveChanges();
            return result;
        }
        catch (Exception ex)
        {  
            CatchError(ex);
            return 3;
        }


    }

Can Any One Tell what mistake i did ?

@JRLambert Already Foreign key value available in Primary key Table — Gopi krishna ch
– Gopi krishna ch, Commented Dec 24, 2015 at 5:04
ThankYou For response guys I used One column as primary key which is the inner exception i solved it — Gopi krishna ch
– Gopi krishna ch, Commented Dec 24, 2015 at 5:17

Fragment · Accepted Answer · 2015-12-24 05:17:53Z

1

As i undestand your code snipped correctly, you don't need to perform operations with objCredentials. Or if you want to change its status, you must call

newPersonEntity.UpdateObject(objCredentials);

And the only reason, why you cannot save changes is incorrect userDetail object fields values. Check that all required fields filled correclty and don't conflict with existing key values, stored in dataBase

answered Dec 24, 2015 at 5:17

Fragment

1,5851 gold badge28 silver badges35 bronze badges

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

Collectives™ on Stack Overflow

Inserting Data Into Db By Entity Framework Throwing Errors

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