private const string spGetElement = "dbo.spGetElement"; // "public.spgetelement"; public List <Element> SelectElements() { List <Element> selectElements = new List <Element>(); using (DbConnection dbConnection = ConnectionFactory.NewDbConnection()) { using (DbCommand dbCommand = CommandFactory.NewStoredProcedureCommand(dbConnection, spGetElement)) { using (IDataReader dataReader = dbCommand.ExecuteReader()) { while (dataReader.Read() == true) { selectElements.Add(new Element ( Convert.ToInt32(dataReader["atomicnumber"]), Convert.ToInt32(dataReader["atomicweight"]), Convert.ToDateTime(dataReader["datecreatedutc"]), Convert.ToDateTime(dataReader["dateupdatedutc"]), Convert.ToDouble(dataReader["density"]), ToNullableInt32(dataReader["groupid"]), Convert.ToInt32(dataReader["id"]), dataReader["name"].ToString(), Convert.ToInt32(dataReader["period"]), dataReader["symbol"].ToString() )); } } } } return(selectElements); }
public SqlDatabase(string name) : this(name, ConnectionFactory.NewDbConnection()) { }
protected Database(string name) : this(name, ConnectionFactory.NewDbConnection()) { }