Duplicate pimary key while inserting Exception in MVC

-
When we generate the scaffolding templates from the existing model for creating read-write and edit.
We face an exception for the duplicate primary key if we do not provided primary key value.
So the Question Is how to autogenerate the next primary key value?

The answer is right here
1) Inside Create() Method Declare following Code.

 // GET: Products/Create
        public ActionResult Create()
        {
            Product product = new Product();
            product.Product_Id = db.Products.Max(item => item.Product_Id)+1;
            return View(product);
        }
 The red color code is newly added code.

And the next time if you see the value of the primary key will be auto-generated.

Comments

Post a Comment

Popular posts from this blog

Code First Approach with Entity Framework

-
Image
 1) To begin with the Code First Approach we need the below Nuget packages in our Project. Microsoft.EntityFrameworkCore Microsoft.EntityFrameworkCore.SqlServer Microsoft.EntityFrameworkCore.Tools Microsoft.EntityFrameworkCore.Design One can easily install the above packages with the nuget package manager or its command line tool. Once installed you will get the below packages stacked in the installed window of nuget package manager
Read more

Getting Ready for Python Development on Ubuntu using VSCode

-
Image
Many People know Python is the most trending programming language in the current world. It's a very demanding programming language in Data Science and Machine Learning. Let's start creating a local environment for complete Python development. 1) Ubuntu System has preinstalled Python. 2) We can also install the Anaconda environment from this link .  3) Downloading VSCode
Read more

Designing Model class with validation in ASP.NET MVC

-
The Generalized Example product model class. As given belowed. using System; // Using Data Annotation Library using System.ComponentModel.DataAnnotations; namespace modelDesigning.Models {     public class Product     {         // Product ID Decalration         // Key defines given Id is primary key         [Key]         // Required Annotation says its compulsory and required field.         [Required]         public int ProductID { get; set; }                         [Required]         // Max Length Annotation gives maximum length for string.         [MaxLength(50)]         public String ProductName { get; set; }         [Required]         public decimal Price { get; set; }         // Maximum length and minimum length of Description.         [MaxLength(100), MinLength(10)]         public string Product_Description { get; set; }     } }
Read more