ASP.NET

namespace Wic_T1
{
    using System;
    using System.Collections.Generic;
    using System.Runtime.Serialization;

     [DataContract]
    public partial class database_WICs
    {
        [DataMember]
        public int ID { get; set; }
        [DataMember]
        public string Name { get; set; }
        public Nullable<System.DateTime> SaleDateTime { get; set; }
        public string Region { get; set; }
        [DataMember]
        public string CUSIP { get; set; }
        [DataMember]
        public string Size__m_ { get; set; }
        public string OriginalRating { get; set; }
        public Nullable<System.DateTime> MaturityDate { get; set; }
        public string Manager { get; set; }
        [DataMember]
        public string priceTalk { get; set; }
        [DataMember]
        public string Cover { get; set; }
        public Nullable<System.DateTime> LastUpdated { get; set; }
        [DataMember]
        public Nullable<System.DateTime> UploadDate { get; set; }
        [DataMember]
        public string Type { get; set; }
        [DataMember]
        public string ISINs { get; set; }
        [DataMember]
        public Nullable<float> Decimal_price { get; set; }
        public string CMBS_spread { get; set; }
        public Nullable<float> CMBS_decimal { get; set; }
        [DataMember]
        public string Current_size { get; set; }
    }
}

<pre lang="c#">public IEnumerable<database_BWICs> GetDate()
        {
            DateTime yesterday = DateTime.Today.AddDays(-1);

            var data = from c in db.database_BWICs
                       where c.UploadDate == yesterday
                       select c;
            return data.ToList();
        }

priyaahh wrote:

If any of the table is not having row, then I am getting no records in my resultant cartesian product table.

public static class DataTableExtensions
{
    public static IEnumerable<DataRow> AsEnumerableNotEmpty(this DataTable table)
    {
        if (table == null) throw new ArgumentNullException("table");
        if (table.Rows.Count != 0) return table.Rows.Cast<DataRow>();
        return new[] { table.NewRow() };
    }
}

var newDatatable = from TowerName in dtTower.AsEnumerableNotEmpty()
                   from CountryName in dtCountry.AsEnumerableNotEmpty()
                   from Level in dtLevel.AsEnumerableNotEmpty()
                   from CityName in dtCity.AsEnumerableNotEmpty()
                   from BandName in dtBand.AsEnumerableNotEmpty()
                   from EType in dtEmploymentType.AsEnumerableNotEmpty()
                   from Skill in dtSkill.AsEnumerableNotEmpty()
                   select new { TowerName, CountryName, Level, CityName, BandName, EType, Skill };