Need Help with College Assignment ADO.Net Entity Model
Hi friends,
I need help with ADO.Net Entity Model Assignment. As per the requirements of my professor
I need to create a database with 3 tables and connect it with ADO.net data model
I have to create a recipe website using master pages template
I have already created the templates
I need you to Create CRUD functionality.
- Create a database on MS-SQL server. The database must contain the following tables:
a.1. ingredient [id, name]
a.2. recipe [id, name, submitted_by, category, cooking_time, servings, …]
a.3. recipe_ingredients [recipe_id, ingredient_id, unit, quantity]
****You would need to create the model in a folder called model****
b. Using ADO.NET and LINQ, add a model for the ingredient table, that supports the following operations:
b.1 Insert a new ingredient in ingredients table in the database
b.2 Retrieve an ingredient with a specific description
Task 2. Update Recipes page to allow user to click on the recipe’s name to get to the new page with details of the recipes that is clicked (Recipe Details page)
Task 3. Add delete button to the Recipe Details page that removes the recipes from the data store.
Task 4. Modify the Search page to show recipes based on 3 criteria: a. Submitted by b. Category c. Name of ingredient (list all recipes containing the ingredient)
Each option is a drop-down list. All 3 criteria have the option
“All” that is default for all three. The result is the logical AND of all the criteria selected. For instance, if a user chooses “Mark” from submitted by, “soup” from category and “potato” from ingredient the result will be all soups recipes submitted by Mark that need potato to be prepared.
*****THIS IS NOT MVC PROJRCT*** ALL CODE MUST BE IN ASP
As mentioned templates have been created****
Requirements
Hi friends,
I need help with ADO.Net Entity Model Assignment. As per the requirements of my professor
I need to create a database with 3 tables and connect it with ADO.net data model
I have to create a recipe website using master pages template
I have already created the templates
I need you to Create CRUD functionality.
- Create a database on MS-SQL server. The database must contain the following tables:
a.1. ingredient [id, name]
a.2. recipe [id, name, submitted_by, category, cooking_time, servings, …]
a.3. recipe_ingredients [recipe_id, ingredient_id, unit, quantity]
****You would need to create the model in a folder called model****
b. Using ADO.NET and LINQ, add a model for the ingredient table, that supports the following operations:
b.1 Insert a new ingredient in ingredients table in the database
b.2 Retrieve an ingredient with a specific description
Task 2. Update Recipes page to allow user to click on the recipe’s name to get to the new page with details of the recipes that is clicked (Recipe Details page)
Task 3. Add delete button to the Recipe Details page that removes the recipes from the data store.
Task 4. Modify the Search page to show recipes based on 3 criteria: a. Submitted by b. Category c. Name of ingredient (list all recipes containing the ingredient)
Each option is a drop-down list. All 3 criteria have the option
“All” that is default for all three. The result is the logical AND of all the criteria selected. For instance, if a user chooses “Mark” from submitted by, “soup” from category and “potato” from ingredient the result will be all soups recipes submitted by Mark that need potato to be prepared.
Skills Required
C
Ado
net
net
Entity
