last entity (page_count) in the above class is not from table. And in the select query I select all the columns from table and one column (page_count) is derived and calculated into the query ....

[Table(Name = "dbo.tblProjects")]
public class ProjectsDto
{
private int _prjId;
[Column(Storage = "_prjId", IsPrimaryKey = true, IsDbGenerated = true)]
public int prjId
{
get { return _prjId; }
set { _prjId = value; }
}

private string _projectName;
[Column(Storage = "_projectName")]
public string projectName
{
get { return _projectName; }
set { _projectName = value; }
}

private string _prjDescription;
[Column(Storage = "_prjDescription")]
public string prjDescription
{
get { return _prjDescription; }
set { _prjDescription = value; }
}

private string _logo;
[Column(Storage = "_logo")]
public string logo
{
get { return _logo; }
set { _logo = value; }
}
private string _prjFriendlyTitle;
[Column(Storage = "_prjFriendlyTitle")]
public string prjFriendlyTitle
{
get { return _prjFriendlyTitle; }
set { _prjFriendlyTitle = value; }
}

private int _page_count;
public int page_count
{
get { return _page_count; }
set { _page_count = value; }
}

}



This my class in which the columns from sql table are mapped, but the last entity (page_count) in the above class is not from table. And in the select query I select all the columns from table and one column (page_count) is derived and calculated into the query . But when the data comes into this column is null… why it is ..? can anyone please tell me..?

Tags: C# (C# 4.0)