Outof Memory Exception

See more:

string

Builder

Hi All,

Basically i am trying to migrate data from SQL Server to SQLCe 4.0; It is an on going process, which means for product versionised DB is managed on SQL Server and i need to create a table in SQLce for desktop application.

Here i am using c# to write a migratory which is migrates data from SQL Server to SQL Ce 4.0

Following is code part:-
// Following statement pulls data from table into Stringbuilder. One of the table contains about 1600000 (Sixteen lack) rows.
StringBuilder strStrings = GetDataToLoad(lstDestTableNeed.Items[z].ToString(), DT, strCols);

When i am trying to convert string builder to List it is showing out of Memory exception, I have tried following three ways. But no luck.

// List<string> strQ = strStrings.ToString().Split('|').ToList();
// IEnumerable<string> strQ = strStrings.ToString().Split('|').AsEnumerable();
//var arrary = strStrings.ToString().Split('|');

help me please.