public IList <FormulaInfo> SelectList()
{
using (DbConnection conn = new DbConnection())
{
using (TableAdapter <FormulaInfo> adapter = TableAdapter <FormulaInfo> .Open())
{
return(adapter.Select().ToList());
}
}
}
public System.Collections.Generic.IList <TableFieldInfo> SelectList()
{
using (DbConnection conn = new DbConnection())
{
using (TableAdapter <TableFieldInfo> adapter = TableAdapter <TableFieldInfo> .Open())
{
return(adapter.Select().ToList());
}
}
}
public IList <ExtractionConfig> SelectConfigs()
{
using (DbConnection conn = new DbConnection())
{
using (TableAdapter <ExtractionConfig> adapter = TableAdapter <ExtractionConfig> .Open())
{
return(adapter.Select().ToList());
}
}
}
public IList <PacketsToSend> SelectAllCacheDataPackets()
{
using (DbConnection conn = new DbConnection())
{
using (TableAdapter <PacketsToSend> adapter = TableAdapter <PacketsToSend> .Open())
{
return(adapter.Select().ToList());
}
}
}
public IList <ProductCategory> SelectList()
{
using (DbConnection conn = new DbConnection())
{
using (TableAdapter <ProductCategory> adapter = TableAdapter <ProductCategory> .Open())
{
return(adapter.Select().ToList());
}
}
}
public IList <SensorType> SelectList()
{
using (DbConnection conn = new DbConnection())
{
using (TableAdapter <SensorType> adapter = TableAdapter <SensorType> .Open())
{
return(adapter.Select().ToList());
}
}
}
public IList <DataFilter> SelectList()
{
using (DbConnection conn = new DbConnection())
{
using (TableAdapter <DataFilter> adapter = TableAdapter <DataFilter> .Open())
{
return(adapter.Select().ToList());
}
}
}
public IList <ExtractValueName> SelectList()
{
using (DbConnection conn = new DbConnection())
{
using (TableAdapter <ExtractValueName> adapter = TableAdapter <ExtractValueName> .Open())
{
return(adapter.Select().ToList());
}
}
}
public T Get()
{
using (TableAdapter <T> adapter = TableAdapter <T> .Open())
{
// Create
//adapter.CreateUpdate(1, "Hello world!");
// Read
T value = adapter.Select().First();
return((T)Convert.ChangeType(value, typeof(T)));
//// Update
//row.Test = "Cheese";
//adapter.CreateUpdate(row);
//// Delete
//adapter.Delete(row1);
}
//return value;
}