Entity framework Context.SaveChanges() not inserting data in the table

Question

I am using Entity framework 4.1, the following method I am using to insert data in the table it is not inserting data in the table.

Method:

    private void InsertSMSStatus(Request request)
    {
        UtilitiesEntities context = new UtilitiesEntities();
        SMSAlertLog alertLog = new SMSAlertLog();
        alertLog.Recipients = request.To;
        alertLog.Sender = From;
        alertLog.Status = Convert.ToInt32(request.ResponseString);
        context.SaveChanges();
        context.Dispose();
    }

The Connection string:

<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0" /></startup><connectionStrings><add name="UtilitiesEntities" connectionString="metadata=res://*/DataModel.SmsEntityModel.csdl|res://*/DataModel.SmsEntityModel.ssdl|res://*/DataModel.SmsEntityModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=bosql1srv;initial catalog=Utilities;integrated security=True;multipleactiveresultsets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" /></connectionStrings></configuration>

Any Idea?

You haven't inserted anything into your context. You need to do something like that: context.AlertLogs.Add(alertLog); context.SaveChanges(); .. depending on your context of course. — Felix Bayer
– Felix Bayer, Commented Jun 3, 2013 at 12:15

Mehmet Ataş · Accepted Answer · 2013-06-03 12:15:25Z

7

You are not adding your entity into context.

context.SMSAlertLogs.Add(alertLog); // name of entity set may change. It might not be SMSAlertLogs 
context.SaveChanges();

answered Jun 3, 2013 at 12:15

Mehmet Ataş

11.6k6 gold badges57 silver badges80 bronze badges

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

Collectives™ on Stack Overflow

Entity framework Context.SaveChanges() not inserting data in the table

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