Implement WPF app to access/ manipulate data of Database through EF6
$30-250 CAD
V teku
Objavljeno pred približno 3 leti
$30-250 CAD
Plačilo ob dostavi
Database-First concept must be enforced. That is reverse engineering from data-base to code must be done first.
When you start your app, it should right away show the initial data in the rele-vant DataGrid: Fruit related info in DataGrid-1 (left DataGrid), Planet related info in DataGrid-2 (middle DataGrid). This initial data should come from the da-tabase tables created from the given .sql file.
Access and manipulation of database tables from the GUI can be done.
Three DataGrid, two ComboBoxes, six Buttons are present in the GUI layout.
When you select an item in Fruit ComboBox, the selected item gets appended in a new row in DataGrid-1.
When you select an item in Planet ComboBox, the selected item gets appended in a row in DataGrid-2.
When you select an item in the DataGrid-1, the selection (if any) at DataGrid-2 should get unselected.
When you select an item in the DataGrid-2, the selection (if any) at DataGrid-1 should get unselected.
An element in DataGrid (i.e. a grid location) should not be editable.
On clicking button “LINQ Project QS” shows relevant rows in DataGrid-3 (right DataGrid). “LINQ Project QS” implies executing LINQ command Project in query syn-tax.
On clicking button “LINQ Filter QS” shows relevant rows in DataGrid-3. “LINQ Fil-ter QS” implies executing LINQ command Filter in query syntax.
On clicking button “LINQ Order Ascending QS” shows relevant rows in DataGrid-3. “LINQ Order Ascending QS” implies executing LINQ command Order Ascending in query syntax.
On clicking button “LINQ Inner Join QS” shows relevant rows in DataGrid-3. “LINQ Inner Join QS” implies executing LINQ command Inner Join in query syntax.
Button “Clear” clears all three DataGrids, clears the relevant entries in the da-tabase, clears the selections in every ComboBox.
Button “Delete selected row” deletes the selected row in DataGrid-1 (left Data-Grid) OR the selected row in DataGrid-2 (middle DataGrid), clears the relevant entry in the database.