Retrieve millions of records from Teradata into Asp.net application

Database
Enthusiast

Retrieve millions of records from Teradata into Asp.net application

Hi,

  I have installed .NET Data Provider for Teradata 15.01 (Visual studio 2013) to connect Teradata to Asp.Net application. In one of my Teradata table I have millons of records.

I am using Entity Framework to retrieve data. And my code is like below

 using (DataAccessLayer.Entities dbContext = new DataAccessLayer.Entities())

      {

        var resultDetailsData = dbContext.MyTable;

        gridDetailsData.DataSource = resultDetailsData;

        gridDetailsData.DataBind();

      }

But when I run this application it gets hang and gives the message

[.NET Data Provider for Teradata] [100038] Command did not complete within the time specified (timeout).

So can anybody tell what are the possible ways by which we can access lagrge data in Asp.net application.

Thanks,

Mahendra

1 REPLY
Teradata Employee

Re: Retrieve millions of records from Teradata into Asp.net application

The TdCommand.CommandTimeout property defaults to 30 seconds. You need to set  it to a larger value or Zero to diable the Command-Timeout.