Upload the excel data using entitframework to mysql db

Question

When uploading the data in mysql database using entityframework below error occured:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(SELECT outstanding_master.CustomerID, outstanding_master.`Na' at line 1

   foreach (DataRow dr in ds.Tables[0].Rows)
            {
                //object value = null;

                outstanding_master master = new outstanding_master();
                {
                    master.CustomerID = dr[0].ToString();
                    //   EntityKey orderKey =
                    // new EntityKey("UploadsEntities.outstanding_master", "CustomerID", master.CustomerID);
                    master.Name = dr[1].ToString();
                    master.PhoneNumber = Convert.ToInt64(dr[2].ToString());
                    master.Address = dr[3].ToString();
                    master.ServiceProviderID = Convert.ToInt32(dr[4].ToString());
                    master.TotalDue = dr[5].ToString();
                    master.LastPaidAmount = dr[6].ToString();
                    master.LastPaidDate = Convert.ToDateTime(dr[7].ToString());
                    master.OutStandingDescription = dr[8].ToString();
                    master.longitudeandlatitude = dr[9].ToString();
                }
                db.outstanding_master.Add(master);
                  db.SaveChanges();
    }

similar problem is here but not cleared stackoverflow.com/questions/14165115/…? — user123
– user123, Commented Jun 2, 2014 at 10:29

user123 · Accepted Answer · 2014-07-01 10:36:03Z

0

Here In my database for outstanding_master table not having the primary key when i added hat it's working fine.

answered Jul 1, 2014 at 10:36

user123

8503 gold badges14 silver badges34 bronze badges

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

Collectives™ on Stack Overflow

Upload the excel data using entitframework to mysql db

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related