How do i add a field that maps to my database table?

Question

I have a situation where I need to add a property that maps to the column of database table .

I already have an running application with property that maps the database column. example

public virtual string ChocoBarPrice { get; set; }

this maps to the column name choco_bar_price .

Now I need to add another Property that needs to map with column name choco_bar_2_price.

This is what I did , I just added a property but I am not sure if this is right way to do it.

public virtual string ChocoBar2Price { get; set; }

How do I do it? I would be thankful for the help.

Praveen Dhatrika · Answer

Well to map a table in DB we create a class  to map a field in a table we do create a property in Class Like say I have a table in tblEmployee and fields as id name gender Now I create my class to map as follwing public class Emp (classname) { public int ID {get;set;} public string Name {get;set;} public string Gender {get;set;} } This is how we generally write in real time projects ... If you find this was helpful please check this as correct answer