Insert new record into database using Entity Framework

asp.net-mvc-2 c# 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?

1
1
6/19/2012 9:03:10 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

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"); 
}
4
6/19/2012 9:03:34 PM

Popular Answer

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.

Sven Grosen

Related Questions

Before adding a new record, make sure it already exists.

The only way to check if a record exists is to query the record and see if anything comes back:...var existingAuthorCount = publishContext.Author.Count(a => a.AuthodSSID == 20); if (existingAuthorCount == 0) { // Do your insert }
c# entity-framework
asked by Jacob

Insert record using entity Framework (database first)

I got a solution, I need to define only the MovieID, MemberID, and not using their object...and use try & catch, to detect if thier the same MovieID (fk) and MemberID (fk) in the same row (because the review don't have is own id in the database)... public bool InsertNewReview(string _MovieID, int _MemberID, string _Text, byte _Rate, DateTime _Rev...
asp.net entity-framework entity-relationship linq-to-entities linq-to-sql
asked by Daniel Ezra

New records inserted in foreign key table when inserting in parent table

I am new to Asp.net MVC and working on a simple blog application (Asp.Net MVC5, EF6) for learning. ...I am using repository pattern for the solution architecture with EF Code first migration, Ninject for DI. On the client side, I am using jQuery Grid for Admin to manage Posts, Categories and Tags. ...- Blog.Model: Post.cs, Category.cs, Tags.cs...pu...
asp.net-mvc-4 entity-framework-6
asked by jarnail

Correct way Entity framework master-detail insert record code for inserting child

I'm new to Entity Framework and tying to learn correct way of updating data....Customer...public partial class Customer { public Customer() { this.Contacts = new ObservableListSource<Contact>(); } public int CustomerId { get; set; } public int CustomerCustomId { get; set; } public string CustomerName { get; set; } ...
.net c# entity-framework
asked by Carlo

Database default value is not inserted while create record by entity framework

Combined my two comments into an answer....Try setting the "StoredGeneratedPattern" attribute of your datetime in the EDMX file to Computed. From the following thread: ...http://www.stackoverflow.com/a/4688135/2488939...To do this, go to the edmx file designer by clicking on your edmx file. Then locate your table and the property. Right-click the c...
asp.net-mvc c# entity-framework sql-server-2008-r2
asked by The Mahahaj

Insert Record in Temporal Table using C# Entity Framework

Probably the simplest solution would be manually edit the .EDMX file and remove all traces of the StartTime and EndTime columns.
c# entity-framework entity-framework-6 sql-server temporal-database
asked by Phi Nguyen

Bulk insert records and get their Id's after bulk insert in Entity Framework

I want to bulk insert 100,000+ rows into a table (which has a identity column which auto increments every time a new row is inserted)....What would be the fastest way to insert the rows with least performance impact?...After all rows are inserted, how do I get the list of ids of the rows that are recently inserted?...Note: I did the following but I...
c# entity-framework entity-framework-6 sql
asked by user3861992

Prevent Adding New Record on Related Table Entity in Entity Framework

I am trying to add new record on my entity. It works fine, the problem is, the related entities are adding new records as well. Is there a way to stop related or 2nd level entities to be inserting new records as well?...Here is my sample Entity Class:...public Tracking() { public string Details { get; set; } //Other properties ...
c# entity-framework entity-framework-6 orm
asked by Willy David Jr

How to increase insert speed using Bulk insert using AddRange and then SaveChanges in Entity Framework

Using AddRange over Add is already a great improvement. It fixes the part that's slow in the Application....However, the ...SaveChanges... still take a lot of time because one database round-trip is made for every entity you save. So if you have 10k entities to insert, 10,000 database round-trip will be made which is ...INSANELY... slow....Disclaim...
c# c#-4.0 entity-framework entity-framework-6
asked by Jonathan Magnan

Entity Framework: Improving Performance when inserting a record in a table with many records

I want to insert a single record into a table with 60 columns (some of them are not required) and 2 million records. It takes about 20 seconds....var package = new Package() { DestinationCityId = city.Id, OriginCityId = RequestDetails.User.Retailer.CityId, State = state, CreatedOn = RequestDetails.DateT...
.net asp.net-web-api c# entity-framework-6 sql-server
asked by Miremad Bagheri

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow