Inserting data based on my selected fields only

Anthony Tan

6y1.1k.NET

Dear Experts,

I am a newbie for ASP.NET and I have a question to seek for your advice.

I am creating a new record in the database & below is the code I am using now in the controller:

public ActionResult Create(TCustomer customer)
{
if (ModelState.IsValid)
{
_CustomerRepository.NewCustomer(customer);
_CustomerRepository.Save();
return RedirectToAction("Index");
}
return View();
}

here is the code in my Repo :

public void NewCustomer(TCustomer customer)
{
_dbContext.TCustomers.Add(customer);
Save();
}

My question is, how can i save the database on the selected fields only?

For example, I have Customer_name, Customer_phone, customer_dob & customer_age

and I just want to select Customer_name, Customer_phone to be inserted into the database. and before I save the customer_name, customer_phone I may need to find turn the data.

Hope you understand what i am saying and advise me.

Many thanks

Ant

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ramesh Palanivel6y ago
Accepted answer
Hi anthony,

There is some data annotation properties are there, where you can restrict the user,

read about NotMapped,Read-only property in Data annotations.
Else , Please try the below code,
public ActionResult Create(TCustomer customer)
        {
            if (ModelState.IsValid)
            {
                 TCustomer _requiredCustomer=new TCustomer(){
//Fill the required customer information in that, avoid unnessary values to be updated.
                     CustomerName=customer.CustomerName;
                  };
                _CustomerRepository.NewCustomer(_requiredCustomer);
                _CustomerRepository.Save();
                return RedirectToAction("Index");
            }
            return View();
        }
Anthony Tan6y ago
Many thanks! it is working
Dinesh Gabhane6y ago
For that you can set values of only Customer_name, Customer_phone fields and other fields as NULL in your customer object. if other fields are not mandatory and allowed NULL then data will get inserted properly.