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:
points The ProductDatabase database has a table named Product.
The Product table has the following columns:
ProductNumber nchar primary key, nulls not allowed
ProductName nvarchar nulls not allowed
ProductDescription nvarchar nulls not allowed
UnitsOnHand int, nulls not allowed
ProductPrice moneydecimal nulls not allowed
points Add records to the Product table.
pointsWrite 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
