static void Main(string[] args)
{
string connString = "Server=(LocalDb)\\MSSQLLocalDb;Integrated Security=true;database=AdventureWorksDW2014";
DataContext context = new DataContext(connString);
var tableProd = context.GetTable <Product>();
var products = from prod in tableProd
where prod.Color == "Black"
select prod;
foreach (Product p in products)
{
Console.WriteLine(p.EnglishProductName);
}
Product product = products.First();
product.Color = "Red";
context.SubmitChanges();
AdventureWorksDataContext awdc = new AdventureWorksDataContext(connString);
var categories = awdc.DimProductCategories;
foreach (DimProductCategory pc in categories)
{
Console.WriteLine(pc.EnglishProductCategoryName);
foreach (var sub in pc.DimProductSubcategories)
{
Console.WriteLine(sub.EnglishProductSubcategoryName);
foreach (var pd in sub.DimProducts)
{
Console.WriteLine(" {0}", pd.EnglishProductName);
}
}
}
var query = from cat in categories
from sub in cat.DimProductSubcategories
from prod in sub.DimProducts
where cat.EnglishProductCategoryName.Contains("Bikes")
select prod;
foreach (var p in query)
{
Console.WriteLine("{0}", p.EnglishProductName);
}
awdc.DimProducts.First().Color = "Dark Red";
awdc.SubmitChanges();
DimProductCategory newCat = new DimProductCategory();
newCat.EnglishProductCategoryName = "New Category 1";
newCat.SpanishProductCategoryName = "Nueva Categoria 1";
newCat.FrenchProductCategoryName = "Nouvelle Categorie 1";
awdc.DimProductCategories.InsertOnSubmit(newCat);
awdc.SubmitChanges();
}
// POST: odata/ProductCategories
public IHttpActionResult Post(DimProductCategory dimProductCategory)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.DimProductCategories.Add(dimProductCategory);
db.SaveChanges();
return(Created(dimProductCategory));
}
// DELETE: odata/ProductCategories(5)
public IHttpActionResult Delete([FromODataUri] int key)
{
DimProductCategory dimProductCategory = db.DimProductCategories.Find(key);
if (dimProductCategory == null)
{
return(NotFound());
}
db.DimProductCategories.Remove(dimProductCategory);
db.SaveChanges();
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult Patch([FromODataUri] int key, Delta <DimProductCategory> patch)
{
Validate(patch.GetEntity());
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
DimProductCategory dimProductCategory = db.DimProductCategories.Find(key);
if (dimProductCategory == null)
{
return(NotFound());
}
patch.Patch(dimProductCategory);
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!DimProductCategoryExists(key))
{
return(NotFound());
}
else
{
throw;
}
}
return(Updated(dimProductCategory));
}
