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; }