IList<WebSite> wsl = new List<WebSite>();
login1 l = new login1();
string q = "select Id, DomainUrl, IsApproved, Date from website where UserId = @UserId";
using (MySqlConnection con = new MySqlConnection(WebConfigurationManager.ConnectionStrings["MySqlConnectionString"].ToString()))
{
using (MySqlCommand cmd = new MySqlCommand(q, con))
{
cmd.Parameters.Add("@UserId", MySqlDbType.Int32).Value = userId;
con.Open();
var reader = cmd.ExecuteReader();
while (reader.Read())
{
var ws = new WebSite();
ws.Id = reader.GetInt32("Id");
ws.DomainUrl = reader.GetString("DomainUrl");
ws.IsApproved = reader.GetBoolean("IsApproved");
ws.User.Id = reader.GetInt32("UserId");
ws.Date = reader.GetDateTime("Date");
wsl.Add(ws);
}
reader.Close();
return wsl;
}
}
I want to make this code as elegant as possible.
For this particular project I cannot use NHibernate
as I have been instructed.
using
the reader. \$\endgroup\$