/// <summary>
/// Showcases the Dataset (Table Adapter) version of Object Relational Mapping
/// </summary>
public static void ORM_DataSet_TableAdapters_Demo()
{
using (ZeroCoolDatabaseTableAdapters.XSDTableAdapter xsdTableAdapter = new ZeroCoolDatabaseTableAdapters.XSDTableAdapter())
{
ClearAndDisplayMessage("Reading all records from the database and showing them here:");
//Read Database Table Records and Display them.
ORM_DataSet_TableAdapters_PrintTable(xsdTableAdapter);
ContinueOn();
ClearAndDisplayMessage("Now I will insert a record..\nPrinting Database Table Records now:");
//Insert Database Table Record
xsdTableAdapter.Insert("Kayla", "Ward", 19);
ORM_DataSet_TableAdapters_PrintTable(xsdTableAdapter);
ContinueOn();
ClearAndDisplayMessage("Now I will Update a record..Can you guess which :)\nPrinting Database Table Records now:");
//Update Database Table
DataTable resultSet = xsdTableAdapter.GetDataByPrim((long)xsdTableAdapter.GetMaxPrim());
DataRow row = resultSet.Rows[0];
if (row != null)
{
row["firstName"] += "Updated";
xsdTableAdapter.Update(row);
}
ORM_DataSet_TableAdapters_PrintTable(xsdTableAdapter);
ContinueOn();
ClearAndDisplayMessage("Now I will Delete a record..Can you guess which :)\nPrinting Database Table Records now:");
//Delete Records from Databae Table
xsdTableAdapter.Delete((long)row["Prim"]);
ORM_DataSet_TableAdapters_PrintTable(xsdTableAdapter);
ContinueOn();
}
}
/// <summary>
/// Prints Records in Database Table for Dataset(TableAdapter)
/// </summary>
public static void ORM_DataSet_TableAdapters_PrintTable(ZeroCoolDatabaseTableAdapters.XSDTableAdapter tableAdapter)
{
DataTable resultSet = tableAdapter.GetData();
foreach (DataRow row in resultSet.Rows)
{
Console.WriteLine("Firstname: {0}\nLastname:{1}\nAge: {2}\n------------", row["Firstname"], row["Lastname"], row["Age"]);
Console.WriteLine("\n");
}
}
