SubmitChanges() throws internal server error

Question

public void RejectOrder(string rejectReason, int selectedNewOrderId)
    {
        SFNewOrder sfNewOrder = mdbDataContext.SFNewOrders.FirstOrDefault(x => x.ID == selectedNewOrderId && !x.IsRejected);

        if (sfNewOrder != null)
        {
            sfNewOrder.IsRejected = true;                              
        }

        SFReject sfReject = new SFReject();

        sfReject.SFNewOrderID = sfNewOrder.ID;
        sfReject.RejectReason = rejectReason;
        sfReject.RejectedDate = DateTime.Now;           
        sfReject.RejectedBy = 2;

        mdbDataContext.SFRejects.InsertOnSubmit(sfReject);
        mdbDataContext.SubmitChanges();
    }

Here I want to change IsRejected property in SFNewOrder Table & Insert a new record In SFReject Table. But I m getting

internal server error

...on

mdbDataContext.submitchanges();

Please help... Thanks in advance.

Internal server error means that something went wrong on the server. Probably some kind of exception raised which you are not aware of. Try to debug to see what kind of exception you get, and then update your question. — Darjan Bogdan, Jul 12 '16 at 05:10
Add try catch to this block of code, and log the error. or place a break point inside the catch block. Then post the error message here. — Zein Makki, Jul 12 '16 at 05:11
Thanks for advice :) Actually i forgot to use try catch block. Error is : "Cannot insert explicit value for identity column in table 'SFReject' when IDENTITY_INSERT is set to OFF." — Renascent, Jul 12 '16 at 05:14
Apologies for my mistake can any one suggest proper solution.Thanks — Renascent, Jul 12 '16 at 05:18

Renascent · Accepted Answer · 2016-07-12T06:15:00.037

public void RejectOrder(string rejectReason, int selectedNewOrderId, User user)
{
    SFNewOrder sfNewOrder = mdbDataContext.SFNewOrders.FirstOrDefault(x => x.ID == selectedNewOrderId && !x.IsRejected);

    if (sfNewOrder != null)
    {
        sfNewOrder.IsRejected = true;                              
    }

    SFReject sfReject = new SFReject();

    sfReject.SFNewOrder = sfNewOrder; 
    sfReject.RejectReason = rejectReason;
    sfReject.RejectedDate = DateTime.Now;           
    sfReject.User= user;

    mdbDataContext.SFRejects.InsertOnSubmit(sfReject);
    mdbDataContext.SubmitChanges();
}

As I have 2 foreign keys in SFReject table I need to assign whole object of that tables. Its working :)

I have to say that this was a very confusing error message thrown by the provider. — Zein Makki, Jul 12 '16 at 05:40

SubmitChanges() throws internal server error

1 Answers1