insert data to db using entity framework showing error

Question

0.00/5 (No votes)

See more:

C#

using (sampleDbEntities sd = new sampleDbEntities())
                    {
                        var t = new AccountDetails
                        {
                           Product_Name = d.Product_Name.ToString(),
                            Product_Name1 = d.Product_Name1,
                            Product_Name2 = d.Product_Name2,
                            Product_Name3 = d.Product_Name3,
                            Product_Name4 = d.Product_Name4,
                            Product_Name5 = d.Product_Name5,
                            Product_Name6 = d.Product_Name6,
                            Product_Name7 = d.Product_Name7,
                            Product_Price = d.Product_Price,
                            Product_Price1 = d.Product_Price1,
                            Product_Price4 = d.Product_Price4,
                            Product_Price2 = d.Product_Price1,
                            Product_Price3 = d.Product_Price1,
                            Product_Price5 = d.Product_Price5,
                            Product_Price6 = d.Product_Price6,
                            Product_Price7 = d.Product_Price7,
                        };

                        sd.Products.Add(t);
                        sd.SaveChanges();

error in sd.products.Add(t);

Posted 17-Oct-15 23:30pm

Khadar Babu Salijamala

Add a Solution

Comments

Kornfeld Eliyahu Peter 18-Oct-15 5:36am

What error?

Khadar Babu Salijamala 18-Oct-15 5:39am

rError 1 The best overloaded method match for 'System.Data.Entity.DbSet<efbatchjob.product>.Add(EFBatchJob.Product)' has some invalid arguments C:\khadar\EFBatchJob\EFBatchJob\BatchJob.cs 125 29 EFBatchJob

Khadar Babu Salijamala 18-Oct-15 6:40am

dbentityvalidationexception was unhandled this was the error message ,how can i resolve this

3 solutions

Solution 1

As the error states System.Data.Entity.DbSet.Add(EFBatchJob.Product) expecting a parameter of type Product, but you pass in a parameter of type AccountDetails...

Posted 17-Oct-15 23:44pm

Kornfeld Eliyahu Peter

Comments

Khadar Babu Salijamala 18-Oct-15 6:34am

An unhandled exception of type 'System.Data.Entity.Validation.DbEntityValidationException' occurred in EntityFramework.dll

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Krunal Rohit · Accepted Answer · 2015-10-17T23:44:00

Solution 2

Quote:
System.Data.Entity.DbSet.Add(EFBatchJob.Product)

It is requiring the Product type parameter and you're passing AccountDetails to it.
Meaning, wrong argument to the method Add();

Pass the argument of type Product to the method sd.Products.Add().

-KR

Posted 17-Oct-15 23:44pm

Krunal Rohit

Comments

Khadar Babu Salijamala 18-Oct-15 6:34am

An unhandled exception of type 'System.Data.Entity.Validation.DbEntityValidationException' occurred in EntityFramework.dll

Khadar Babu Salijamala · Accepted Answer · 2015-10-18T00:51:00

C#

using (sampleDbEntities sd = new sampleDbEntities())
                   {

                       var t = new Product
                       {
                           Product_Name = d.Product_Name,
                           Product_Name1 = d.Product_Name1,
                           Product_Name2 = d.Product_Name2,
                           Product_Name3 = d.Product_Name3,
                           Product_Name4 = d.Product_Name4,
                           Product_Name5 = d.Product_Name5,
                           Product_Name6 = d.Product_Name6,
                           Product_Name7 = d.Product_Name7,
                           Product_Price = d.Product_Price,
                           Product_Price1 = d.Product_Price1,
                           Product_Price4 = d.Product_Price4,
                           Product_Price2 = d.Product_Price1,
                           Product_Price3 = d.Product_Price1,
                           Product_Price5 = d.Product_Price5,
                           Product_Price6 = d.Product_Price6,
                           Product_Price7 = d.Product_Price7

                       };
                       sd.Products.Add(t);
                       sd.SaveChanges();
             }
            }
          }

insert data to db using entity framework showing error

3 solutions

Solution 1

Solution 2

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us