In my c# application I have a string array defined as:
string[,] TranArr = new string[999,20]
I am reading data into this array from an excel spreadsheet (MS Excel 2007 xlsx) via an OdbcDataReader. One spreadsheet cell value is approx. 400 characters in length but when I read it into my array it is truncated to 245 characters. Any idea why this might be happening ?
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!