How to save calculated field in Microsoft SQl Server

Its just that I want to auto calucate Total = price*quanity & also wish to store it permanently in database the calculated field (total).using code first approach in mvc web applicaition 2019..

what should be the code in Product Model for taking toal as a calculated field = price*quanity .

what should be the code in contrroller and view regarding displaying and storing calculated field peramently in Microsoft Sql Server 2019  ?

Thanks in Advance

Hello Suman,

Since the 'Total' property is read-only, you cannot set its value directly.

I Would suggest you to change your Total property to get and set; so it will not create any issue.

 public float Total { get; set; }

Thanks

Naimish Makwana

what changes are needed in view and controller 

run time error coming cannot set data to readonly ie total (calculated field). 

Hello Suman,

To Add Total Calucated field in database table. You need to do following things

1. Add Total Field in your Model Ex. here is Product class, add new property as Total with decimal Datatype.

2. You nedd to run the migration to update the database schema.

3. In your controller action method, you can calculate the 'Total' field using the values of other fields (e.g., Product_Qty and Product_Price) and assign it to the 'Total' property of the model object.

4. You can use the SaveChanges method of the DbContext object to save the changes to the database.

Example :

// Create a new product object
var product = new Product 
{
    Product_name = "Test",
    Product_Quality = "yonex",
    Product_Qty = 50,
    Product_Price = 200,
    Product_Date = DateTime.Now
};

// Calculate the total field
product.Total = product.Product_Qty * product.Product_Price;

// Save the product object to the database using Entity Framework
using (var db = new ProductContext())
{
    db.Products.Add(product);
    db.SaveChanges();
}

Thanks

Naimish Makwana