Entity / Code First / SQL Database - Same parameter but differents values

Question

Context

I'm a beginner in Entity / CodeFirst and SQL database.

I would to build a table with the same parameter:

-----------------------------------------
| ID | F1 | F2 | F3 | F4 | F5 | F6 | F7 |
-----------------------------------------
|  1 |1000| 500| 250| 100| 50 |    |    |
|  2 | 500| 250| 125|    |    |    |    |
|  3 | 250| 125| 100|    |    |    |    |
|  4 | 200| 100|    |    |    |    |    |
|  5 | 100| 50 |    |    |    |    |    |
-----------------------------------------

Fs1 to 7 is a list the same parameter with different value.

Questions

• What's the correct way to describe it in taking into Code First consideration?

I suppose this way isn't correct...

    public class FsTable
    {
        public int Id { get; set; }
        public double F1 { get; set; }
        public double F2 { get; set; }
        public double F3 { get; set; }
        public double F4 { get; set; }
        public double F5 { get; set; }
        public double F6 { get; set; }
        public double F7 { get; set; }

    }

• What's the correct way to fill this table with values above?

Answer 1

First of all think about colums without value. Should they be nullable or not? You can seed your Db from the Seed method.

If you are using console aplication you need to invoke some operation over the database so you can create it

Ps. Check out Repository Pattern