views:

55

answers:

0

Hi,

I want to keep some timesries data in my database. Raw data are something like below:

Time Col1 Col2 Col3
8:00 12 18 20
8:30 14 12 13
9:00 17 15 14

Where number of columns and time steps are undetermined. So I created three tables like this:

TimeStamp(ID,Time)
Columns(ID,Name)
Values(ID,TimeStampID,ColumnID,Value)

Now my question is how can I bind this data to a DataGridView using EF? I want my data to be editable by user (Add,Delete for rows and Edit in each cell) in form of a all-in-one table.

Thank you.