static void Main()
{
using (AdventureWorksDW2014Entities db = new AdventureWorksDW2014Entities())
{
var query = from prod in db.DimProduct
select prod;
foreach (DimProduct p in query)
{
Console.WriteLine($"{p.ProductKey}, {p.ModelName}");
}
var q2 = from cat in db.DimProductCategory
join prod in db.DimProduct on cat.ProductCategoryKey equals prod.ProductSubcategoryKey
where cat.EnglishProductCategoryName.ToLower().Contains("bike")
select prod;
foreach (var p in q2)
{
Console.WriteLine($"{p.DimProductSubcategory.EnglishProductSubcategoryName}, {p.ModelName}");
}
DimProductCategory cat1 = new DimProductCategory();
cat1.EnglishProductCategoryName = "new category";
cat1.FrenchProductCategoryName = "nouvelle catégorie";
cat1.SpanishProductCategoryName = "nueva categoría";
using (AdventureWorksDW2014Entities dba = new AdventureWorksDW2014Entities())
{
dba.Database.ExecuteSqlCommand("DELETE from DimProductCategory WHERE EnglishProductCategoryName='new category'");
dba.DimProductCategory.Add(cat1);
dba.SaveChanges();
}
using (AdventureWorksDW2014Entities dbquery = new AdventureWorksDW2014Entities())
{
var product1 = dbquery.DimProduct.Find(1);
var products = dbquery.DimProduct.SqlQuery("select * from DimProduct").ToList();
var productColorsQuery = dbquery.Database.SqlQuery <string>("select distinct Color from DimProduct");
List <string> names = productColorsQuery.ToList();
int affected = dbquery.Database.ExecuteSqlCommand("UPDATE DimCustomer SET Title='Dr' WHERE CustomerKey=1234");
}
Console.ReadLine();
}
}
static void Main()
{
using (AdventureWorksDW2014Entities db = new AdventureWorksDW2014Entities())
{
var query = from prod in db.DimProduct
select prod;
foreach (DimProduct p in query)
{
Console.WriteLine($"{p.ProductKey}, {p.ModelName}");
}
var q2 = from cat in db.DimProductCategory
join prod in db.DimProduct on cat.ProductCategoryKey equals prod.ProductSubcategoryKey
where cat.EnglishProductCategoryName.ToLower().Contains("bike")
select prod;
foreach (var p in q2)
{
Console.WriteLine($"{p.DimProductSubcategory.EnglishProductSubcategoryName}, {p.ModelName}");
}
DimProductCategory cat1 = new DimProductCategory();
cat1.EnglishProductCategoryName = "new category";
cat1.FrenchProductCategoryName = "nouvelle catégorie";
cat1.SpanishProductCategoryName = "nueva categoría";
using (AdventureWorksDW2014Entities dba = new AdventureWorksDW2014Entities())
{
dba.Database.ExecuteSqlCommand("DELETE from DimProductCategory WHERE EnglishProductCategoryName='new category'");
dba.DimProductCategory.Add(cat1);
dba.SaveChanges();
}
using (AdventureWorksDW2014Entities dbquery = new AdventureWorksDW2014Entities())
{
var product1 = dbquery.DimProduct.Find(1);
var products = dbquery.DimProduct.SqlQuery("select * from DimProduct").ToList();
var productColorsQuery = dbquery.Database.SqlQuery<string>("select distinct Color from DimProduct");
List<string> names = productColorsQuery.ToList();
int affected = dbquery.Database.ExecuteSqlCommand("UPDATE DimCustomer SET Title='Dr' WHERE CustomerKey=1234");
}
Console.ReadLine();
}
}