Values not inserted in table

Asked Aug 23 '19 at 08:01

Active Aug 23 '19 at 08:21

Viewed 41 times

I have company table where values are inserted

public int SaveCompany(Company objCompany)
{

  int CompanyID = 0

  try
  {
    using (var context = new Cubicle_EntityEntities())
    {
      context.Companies.Add(objCompany);        //add entity to the add method
      int res = context.SaveChanges();       //insert it into table
      if (res > 0)
      {
        Debug.WriteLine("Data Inserted Successfully");
      }
      else
      {
        Debug.WriteLine("Try Again");
      }
      CompanyID = objCompany.CompanyId;
      Debug.WriteLine("CompanyId " + CompanyID);

    }
  }
  catch (Exception ex)
  {

     CompanyID = 0;
     bool rethrow = UserInterfaceExceptionHandler.HandleException(ref ex);
     throw ex;
   }       

   return CompanyID;
 }

Every time I get res 1,but data not inserted in table.

edited Aug 23 '19 at 08:21

mcalex

6,628
5
50
80

asked Aug 23 '19 at 08:01

user11887906

Do you get any value in CompanyID = objCompany.CompanyId;? – Matt Aug 23 '19 at 08:24
yes I get incremented value for company id everytime – user11887906 Aug 23 '19 at 08:40
And selecting from database works fine? – Matt Aug 23 '19 at 08:42
yes it works fine – user11887906 Aug 23 '19 at 09:10
This should work fine. Take a look at this, maybe that helps you. https://stackoverflow.com/questions/39552207/entityframework-6-0-0-0-reads-data-but-it-is-not-inserting – Matt Aug 23 '19 at 09:13

Values not inserted in table

0 Answers0