ASP.NET

IEnumerable<MyData> GetData()
{
  IEnumerable<MyData> enumerable = null;
  try
  {
    var query = 
      from m in dataContext
      select m;

    enumerable = query.AsEnumerable();
  }
  catch (SQLException ex)
  {
    if (ex.SomeCheck)
    {
       // Empty enumerator
       var list = new List<MyData>();
       enumerable = list;
    }
    else
    {
       // Unknown problem --- rethrow the exception
       throw;
    }
  }

  return enumerable;
}

indian143 wrote:

I dont know how to see that, but he told me.

from a in quarterlyUpdateSubscription
join b in parallelDataContext.teBinaryDatas on  
a.DeltaReportBinaryDataID equals b.BinaryDataID
select b.Data

 public string GetQuarterlyUpdateTUCDataXml( int quarterlyUpdateJobId, int quarterlyUpdateSubscriptionId)
        {
            string strQuarterlyUpdateDeltaReport = null;            
 
            var quarterlyUpdateSubscription = parallelDataContext.teQUTUDatas.Where(c => c.QuarterlyUpdateJobID ==
     quarterlyUpdateJobId && c.QuarterlyUpdateSubscriptionID == quarterlyUpdateSubscriptionId).ToList();
 
            if ((quarterlyUpdateSubscription != null) && 
(quarterlyUpdateSubscription.Count > 0))
            {
                byte[] encryptedBytes = (from a in quarterlyUpdateSubscription
                                         join
                                             b in parallelDataContext.teBinaryDatas on  
 
a.DeltaReportBinaryDataID equals b.BinaryDataID
select b.Data).FirstOrDefault().ToArray();
 
                strQuarterlyUpdateDeltaReport = (encryptedBytes != null) ?
                  objCommon.GetDecryptedReportString(encryptedBytes) : ""; //objCommon.GetDecryptedReport(encryptedBytes); //                       
            }
            
            return strQuarterlyUpdateDeltaReport;
        }

ToList()

ToArray()

SayamiSuchi wrote:

it gave error