/// <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"); } }