public static Bundesland GetById(int id)
{
string strSql = "SELECT * FROM TAB_BUNDESLAND WHERE BundeslandId=?id";
using (var conn = new MySqlConnection(_strConn))
{
try
{
var bundeslend = new Bundesland();
var cmd = new MySqlCommand(strSql, conn);
conn.Open();
cmd.Parameters.AddWithValue("?id", id);
var reader = cmd.ExecuteReader();
if (reader.Read())
{
bundeslend = GetDataFromReader(reader);
}
reader.Close();
return bundeslend;
}
catch (Exception)
{
return null;
}
}
}
private static Bundesland GetDataFromReader(IDataRecord reader)
{
var bl = new Bundesland();
if (!Convert.IsDBNull(reader["BundeslandID"]))
{
bl.Id = reader.GetInt16(reader.GetOrdinal("BundeslandID"));
}
if (!Convert.IsDBNull(reader["Bundesland"]))
{
bl.Name = reader.GetString(reader.GetOrdinal("Bundesland"));
}
return bl;
}
