Maryam Ilyas

Maryam Ilyas

  • 1.9k
  • 2
  • 1.6k

query for continuous data in linq to sql

Dec 27 2014 2:10 AM
i need to write a query that take 10 values from my SQL server databse at a time in a way that it takes 1 to 10 values first time than next time it takes 2 to 11.. than 3 to 12.. and so on to plot ECG continuous Graph for windows phone 8 application (C#).. in LINQ to SQL format.. and also same query for ADO.Net (SQL query) for web application in C#
Structure of Table is:
Create table ECG(Reading_ID int IDENTITY(1,1) not null CONSTRAINT id PRIMARY KEY, Date_Time datetime not null default CURRENT_TIMESTAMP,
Value nvarchar(10) not null ) 

Answers (1)