Question

Using C#

Create a database that stores baseball player information. You will have the following columns. You will need to have the ability to add rows and display the records.

You may use LINQ or Given example using an access accdb file...

Name string

Batting Average floating, decimal, double

team string

jersey number int

ID autonumber

Answer 1

public class MyBaseballPlayers : DataContext {

public Table<BaseballPlayer> BaseballPlayers;

public MyBaseballPlayers(string connection) : base(connection) { } }

[Table(Name = "BaseballPlayerTable")]

public class BaseballPlayer {

[Column(IsPrimaryKey = true)] public int ID AUTOINCREMENT;

[Column] public string Name;

[Column] public int JerseyNumber;

[Column] public double BattingAverage ;

[Column] public string Rating;

}

Do ask if any doubt. Please upvote.