public static Query CreateQuery()
{
DataContext dataContext = new DataContext();
dataContext.AddTablesAndRelations(Databases.NorthwindDataSet);
dataContext.AddTablesAndRelations(Databases.JoinTablesDataSet);
dataContext.AddTablesAndRelations(Databases.AdventureWorksCinemaDataSet);
Query query = new Query(dataContext);
return query;
}
public static Query CreateQuery()
{
DataContext dataContext = new DataContext();
dataContext.AddTablesAndRelations(Databases.NorthwindDataSet);
dataContext.AddTablesAndRelations(Databases.JoinTablesDataSet);
dataContext.AddTablesAndRelations(Databases.AdventureWorksCinemaDataSet);
Query query = new Query(dataContext);
return(query);
}
public static string GetData()
{
var result = "";
var dataSet = new DataSet();
dataSet.ReadXml(@"C:\demos\northwind.xml");
var dataContext = new DataContext();
dataContext.AddTablesAndRelations(dataSet);
var sql = @"
SELECT e.FirstName + ' ' + e.LastName
FROM Employees e
WHERE e.Birthdate.AddYears(65) < GETDATE()
";
var query = new Query(sql, dataContext);
var results = query.ExecuteDataTable();
var values = results.Rows.Cast <DataRow>().Select(r => (string)r[0]);
result = string.Join(Environment.NewLine, values);
return(result);
}
public static string GetData()
{
string result = "";
DataSet dataSet = new DataSet();
dataSet.ReadXml(@"C:\demos\create-netstandard\northwind.xml");
DataContext dataContext = new DataContext();
dataContext.AddTablesAndRelations(dataSet);
string sql = @"
SELECT FirstName + ' ' + LastName Name,
Birthdate.AddYears(65) RetirementDate
FROM Employees
WHERE Birthdate.AddYears(65) < GETDATE()
";
Query query = new Query(sql, dataContext);
DataTable resultsTable = query.ExecuteDataTable();
foreach (DataRow row in resultsTable.Rows)
{
string name = Convert.ToString(row["Name"]);
DateTime retirementDate = Convert.ToDateTime(row["RetirementDate"]);;
result += name + ": " + retirementDate + "\r\n";
}
return(result);
}
public static string[] GetRetiredEmployees(string path)
{
var dataSet = new DataSet();
dataSet.ReadXml(path);
var dataContext = new DataContext();
dataContext.AddTablesAndRelations(dataSet);
var sql = @"
SELECT e.FirstName + ' ' + e.LastName
FROM Employees e
WHERE e.Birthdate.AddYears(65) < GETDATE()";
var query = new Query(sql, dataContext);
var results = query.ExecuteDataTable();
var values = results.Rows.Cast <DataRow>().Select(r => (string)r[0]);
return(values.ToArray());
}
public static string GetEmployeeFromCountry(string filterCountry = "UK")
{
DataSet dataSet = new DataSet();
dataSet.ReadXml("northwind.xml");
var dataContext = new DataContext();
dataContext.AddTablesAndRelations(dataSet);
var sql = @"
SELECT e.FirstName + ' ' + e.LastName
FROM Employees e
WHERE e.Country = '" + filterCountry + "'";
var query = new Query(sql, dataContext);
var results = query.ExecuteDataTable();
var values = results.Rows.Cast <DataRow>().Select(r => (string)r[0]);
var result = string.Join(Environment.NewLine, values);
return(result);
}
public void DataContext()
{
DataContext dataContext = new DataContext();
ExpectArgumentNull("dataSet", delegate { dataContext.AddTablesAndRelations(null); });
}
public void DataContext()
{
DataContext dataContext = new DataContext();
ExpectArgumentNull("dataSet", delegate { dataContext.AddTablesAndRelations(null); });
}
