public List <IDataModel> ReadAll() { List <IDataModel> DATAMODELLCs = new List <IDataModel>(); try { MySqlConnection connection = DatabaseHelper.GenerateConnection(); connection.Open(); MySqlCommand command = new MySqlCommand("select_all_DATAMODELLC", connection); command.CommandType = CommandType.StoredProcedure; DataTable results = new DataTable(); MySqlDataAdapter dataAdapter = new MySqlDataAdapter(command); dataAdapter.Fill(results); foreach (DataRow row in results.Rows) { DATAMODELUC DATAMODELLC = new DATAMODELUC(); DATAMODELLC.PROPERTY = row[""].ToString(); DATAMODELLCs.Add(DATAMODELLC); } connection.Close(); } catch (Exception err) { throw err; } return(DATAMODELLCs); }
public List <IDataModel> ReadAll() { List <IDataModel> DATAMODELLCs = new List <IDataModel>(); //test DATAMODELUC DATAMODELLC = new DATAMODELUC(); DATAMODELLC.PROPERTY = SOMEVALUE; DATAMODELLCs.Add(DATAMODELLC); //database call return(DATAMODELLCs); }