Insert new record into database using Entity Framework

Question

I have a table in my database like this:

[id] [uniqueidentifier] NOT NULL,
[user_id] [uniqueidentifier] NOT NULL,
[download_type] [nvarchar](50) NOT NULL,
[download_id] [nvarchar](50) NOT NULL,
[download_date] [datetime] NOT NULL,
[user_ip_address] [nvarchar](20) NOT NULL,

The id is defined to be the primary key.

I want to insert a new record into this table. Here is my code I cannot get to work.

CustomerPortalEntities_Customer_Downloads dbcd = new CustomerPortalEntities_Customer_Downloads();

public ActionResult Download(string id)
{
    var collection = new FormCollection();
    collection.Add("user_id", Membership.GetUser().ProviderUserKey.ToString());
    collection.Add("download_type", "Car");
    collection.Add("download_id", id);
    collection.Add("download_date", DateTime.Now.ToString());
    collection.Add("user_ip_address", Request.ServerVariables["REMOTE_ADDR"]);            

    dbcd.AddToCustomer_Downloads(collection);

    return Redirect("../../Content/files/" + id + ".EXE");
}

The errors I get is on the line dbcd.AddToCustomer_Downloads(collection);

The best overloaded method match for 'CustomerPortalMVC.Models.CustomerPortalEntities_Customer_Downloads.AddToCustomer_Downloads(CustomerPortalMVC.Models.Customer_Downloads)' has some invalid arguments

Argument '1': cannot convert from 'System.Web.Mvc.FormCollection' to 'CustomerPortalMVC.Models.Customer_Downloads'

What do I need to change to make this work?

RePierre · Accepted Answer · 2012-06-19 21:03:34Z

4

You need to provide an object of type CustomerPortalMVC.Models.Customer_Downloads to method AddToCustomer_Downloads and then call SaveChanges on your data context like this:

public ActionResult Download(string id) 
{ 
    var item = new CustomerPortalMVC.Models.Customer_Downloads(); 
    item.user_id = Membership.GetUser().ProviderUserKey.ToString(); 
    item.download_type = "Car"; 
    item.download_id = id; 
    item.download_date = DateTime.Now.ToString(); 
    item.user_ip_address = Request.ServerVariables["REMOTE_ADDR"];             
    dbcd.AddToCustomer_Downloads(item); 
    dbcd.SaveChanges(); 
    return Redirect("../../Content/files/" + id + ".EXE"); 
}

answered Jun 19, 2012 at 21:03

RePierre

9,5762 gold badges24 silver badges38 bronze badges

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

Comments

Sven Grosen · Accepted Answer · 2012-06-19 20:59:59Z

1

You need to create an instance of your Customer_Downloads class and pass that to your AddToCustomer_Downloads method. The error message is telling you that the interface for that method expects a Customer_Downloads object but you are passing it a FormCollection object.

answered Jun 19, 2012 at 20:59

Sven Grosen

5,6363 gold badges33 silver badges56 bronze badges

1 Comment

Mr Lahey Over a year ago

Man I knew it was something dumb a simple, thanks that worked!

Collectives™ on Stack Overflow

Insert new record into database using Entity Framework

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related