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

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

Bids

I can do this work for you $40

hire me. i can do this.

nadeemilyas19 Level 3

order now!

custom service only my client $1

order mee here

primeit24 Level 1

order now!

Bid On Listing Created 9 years ago in Programming

Avg Time	Count	SQL	Max	Min
0.312925	1	SELECT A.*, B.seo, B.name as categoryname, C.username, C.userlevel, C.lastlogin, C.ip, C.profilepicture FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID ORDER BY A.viewcount desc LIMIT 0,40	0.312925	0.312925
0.105445	1	SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 52796 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%C Ado net net Entity%' ) LIMIT 4	0.105445	0.105445

demonguru18

SEOClerks

Need Help with College Assignment ADO.Net Entity Model

Need Help with College Assignment ADO.Net Entity Model

Requirements

Skills Required

Bids

I can do this work for you $40

custom service only my client $1

Other jobs by demonguru18

Top Sellers

New Services

Top Services

Invalid SQL

Expensive SQL

Suspicious SQL

Match	Count	SQL	Script
SELECT * FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.wantid='52796' AND A.category=B.CATID AND A.USERID=C.USERID	1	SELECT A.*, B.name, B.seo, C.username, C.userlevel, C.footer_code, C.rating, C.ratingcount, C.googleplus_profile, C.total_recommendations, C.USERID, C.profilepicture, C.average_response_time, C.lastlogin, C.addtime FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.wantid='52796' AND A.category=B.CATID AND A.USERID=C.USERID	/opt/clerks-staging/docroot/viewwant.php 163 () ()
SELECT * FROM ratings_buyer WHERE USERID=60062	1	SELECT sum(good) as thumbup, sum(bad) as thumbdown FROM ratings_buyer WHERE USERID=60062	/opt/clerks-staging/docroot/include/functions/main.php 19523 GetRatingsAsBuyerTotal() ()
SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 52796 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%C Ado net net Entity%' ) LIMIT 4	1	SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 52796 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%C Ado net net Entity%' ) LIMIT 4	/opt/clerks-staging/docroot/viewwant.php 551 () ()
SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 52796 AND A.category=B.CATID AND A.active=1 AND A.USERID=60062 LIMIT 4	1	SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 52796 AND A.category=B.CATID AND A.active=1 AND A.USERID=60062 LIMIT 4	/opt/clerks-staging/docroot/viewwant.php 568 () ()
SELECT * FROM wantcomments a, seoclerks.members b WHERE a.PID='52796' AND a.USERID=b.USERID and b.status='1' AND a.status=1 order by a.CID asc	1	SELECT a.comment, a.USERID, a.CID, a.time_added, a.istranslated, a.parentid, b.username, b.profilepicture FROM wantcomments a, seoclerks.members b WHERE a.PID='52796' AND a.USERID=b.USERID and b.status='1' AND a.status=1 order by a.CID asc	/opt/clerks-staging/docroot/viewwant.php 835 () ()
UPDATE wanttobuy SET viewcount = viewcount + 1 WHERE wantid='52796'	1	UPDATE wanttobuy SET viewcount = viewcount + 1 WHERE wantid='52796'	/opt/clerks-staging/docroot/include/functions/main.php 1729 update_wantviewcount() ()
SELECT * FROM wantbids as w, seoclerks.members AS m WHERE w.active=1 AND m.USERID=w.USERID AND m.status=1 AND w.USERID>0 AND w.wantid='52796' ORDER BY w.bidid ASC	1	SELECT w.bidid, w.PID, w.comment, w.title, w.pricepublic, w.USERID, w.adjustedprice, w.ip, m.profilepicture FROM wantbids as w, seoclerks.members AS m WHERE w.active=1 AND m.USERID=w.USERID AND m.status=1 AND w.USERID>0 AND w.wantid='52796' ORDER BY w.bidid ASC	/opt/clerks-staging/docroot/viewwant.php 1192 () ()
SELECT * FROM seoclerks.members as m WHERE m.USERID=539895	1	SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=539895	/opt/clerks-staging/docroot/viewwant.php 1258 () ()
SELECT * FROM seoclerks.members as m WHERE m.USERID=520868	1	SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=520868	/opt/clerks-staging/docroot/viewwant.php 1258 () ()
SELECT * FROM categories_wanttobuy	1	SELECT * FROM categories_wanttobuy	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()
SELECT * FROM posts WHERE USERID=60062	1	SELECT sum(positive_ratings) as thumbup, sum(negative_ratings) as thumbdown FROM posts WHERE USERID=60062	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetBuyerRatingsTotal()
SELECT * FROM categories	1	SELECT * FROM categories	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()
select * from categories_software order by name asc	1	select * from categories_software order by name asc	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetSoftwareCategories()
select * from categories_wanttobuy order by name asc	1	select * from categories_wanttobuy order by name asc	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_wantcategories()
select * from categories_wanttotrade order by name asc	1	select * from categories_wanttotrade order by name asc	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories()
SELECT * FROM seoclerks.members WHERE USERID='539895'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='539895'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='520868'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='520868'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='60062'	1	SELECT profile_data FROM seoclerks.members WHERE USERID='60062'	/opt/clerks-staging/docroot/include/functions/main.php 1927 getUserBackground() include()

Response	19 hours
Expected delivery	3 days
Ratings	0