Create database file and insert all records in text file

Assignment Help Database Management System

Reference no: EM131940079

Topic: Read a text file and build a localDB

Problem: Read a text file and build a localDB.

Entity Framework Database First - Build an app that executes a query against the Students table of the studentGrade database.

1. Create database file (name it as studentGrade.mdf ) and insert all records in text file csvDBData.txt. You may choose to use whichever way that you like to create/populate your database file.

Note: You should add extra records in your database.

"YourLastname, YourFirstname",JR,77,4,CSCI1170,1170,A,8,4

"YourLastname, YourFirstname",JR,77,4,CSCI2170,2170,A,8,4

2. LINQ to DB - Entity Framework Database First

Your program will generate:

List of students for each class Class (FR, SO, JR, SR) ordered by GPA (large to small) then ordered by CSCI GPA.

Each student detail to be displayed should have concatenated "Course" and "FinalGrade".

For example the record to display for "Barrett, Philip"

"Barrett, Philip",JR,87,1.6664, CSCI1000 B+ CSCI1160B CSCI1170D CSCIELLED B 1910B 1920 C MATHELLED B ,8,2

Attachment:- Assignment Files.rar

Reference no: EM131940079

Questions Cloud

Dog training academy in connecticut : Matt owns a ski instruction school in the Berkshire Mountains, a dog training academy in Connecticut, and an investment house in Boston.

Patient care from a hospital profitability perspective : Which is more important in managed care, the capital and organizational ability of the hospital

Calculate the price at which each ordinary share was issued : Calculate the price at which each ordinary share was issued in the current year and Calculate the total asset value of Diraster as at 31 January 2010

Discount rate is appropriate for stock-what is its value : Afterwards, a more stable 5.00% growth rate can be assumed. If a 10.00% discount rate is appropriate for this stock, what is its value?

Create database file and insert all records in text file : Problem: Read a text file and build a localDB. Create database file (name it as studentGrade.mdf ) and insert all records in text file csvDBData.txt

Describe how the various health components of public health : Describe how the various health components of the public health infrastructure have contributed to the gains described in the readings and resources.

Portfolio variance minimization process : Which constraints do you include in the Markowitz’s portfolio variance minimization process? Assume no short sale is allowed.

What is the significance or impact of the event : Once you have identified such an event, you must write a concise report about the event. In your opinion, what the significance or impact of the event is/was.

Assess the effects of market shifts and declines on channel : A wide variety of channel options exists today. Generally, the goal of the channel arrangement is to maximize the efficiencies of distribution.

User Account

All Pages