ASP.NET

<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 };