Question: Create a ProductDatabaseApp. STEPS: [ 1 0 points ] The ProductDatabase database has a table named Product. The Product table has the following columns: ProductNumber

Create a ProductDatabaseApp.
STEPS:
[10 points] The ProductDatabase database has a table named Product.
The Product table has the following columns:
ProductNumber nchar(5), primary key, nulls not allowed
ProductName nvarchar(50), nulls not allowed
ProductDescription nvarchar(50), nulls not allowed
UnitsOnHand int, nulls not allowed
ProductPrice money/decimal, nulls not allowed
[5 points] Add 10 records to the Product table.
[30 points][Write an application that connects to the ProductDatabase.
The application should use LINQ to SQL to interact with the database.
It should initially display all the products in the database sorted by units on hand, in descending order.
It should allow the user to search for products with more units on hand than a specified amount, and fewer units on hand than a specified amount.
It should allow the user to search for products by ProductNumber.
It should allow the user to specify a minimum and a maximum price, and then display the products within that range of prices.
The user should be able to ADD a new record.
The user should be able to DELETE the selected record.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!