public List<Product> GetProducts()
{

StringBuilder json = new StringBuilder();

SqlConnection con = new SqlConnection(); //create connection to sql (connectionstrig exist in appconfig)
con.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings.ToString();
string str = "select * from products";
SqlCommand comm = new SqlCommand(str, con);

con.Open();
SqlDataReader reader = comm.ExecuteReader();

*/

List<Product> products = new List<Product>();

while (reader.Read())
{
// products.Add(new Product { AddDate = reader.GetDateTime(4), Comment = reader.GetString(4), Image = reader.GetString(1), Price = reader.GetString(1), SubCatergory = reader.GetInt32(1), Title = reader.GetString(1), Url = reader.GetString(1), UserId = reader.GetInt32(1) });

}

con.Close();
return products;