public static void DeleteItem(IBookCatalogItem itemToDelete)
{
BookCatalog bookCatalog = new BookCatalog( );
DeleteItem(bookCatalog, itemToDelete);
bookCatalog.SubmitChanges( );
}
public static void UpdateExistingData( )
{
BookCatalog bookCatalog = new BookCatalog( );
Category category = bookCatalog.Categories.Single(c => c.Name == "Programming Practices");
category.Name = "Technical Practices";
bookCatalog.SubmitChanges( );
Console.WriteLine("*** UpdateExistingData: Category name updated to " + category.Name);
}
private static void DeletingData( )
{
BookCatalog bookCatalog = new BookCatalog( );
Category category = bookCatalog.Categories.Single(c => c.Name == "Java");
bookCatalog.Categories.DeleteOnSubmit(category);
bookCatalog.SubmitChanges( );
Console.WriteLine("*** DeletingData: Removed " + category.Name + "Category");
}
private static void DeletingDataInMtoMRelationship( )
{
BookCatalog bookCatalog = new BookCatalog( );
Book rubyBook = bookCatalog.Books.Single(book => book.Title.Contains("Programming Ruby 1.9"));
bookCatalog.Books.DeleteOnSubmit(rubyBook);
bookCatalog.SubmitChanges( );
Console.WriteLine(" *** DeletingDataInMtoMRelationship: Deleted " + rubyBook.Title);
}
private static void AddNewData( )
{
Category category = new Category( )
{
Name = "Java"
};
BookCatalog bookCatalog = new BookCatalog( );
bookCatalog.Categories.InsertOnSubmit(category);
bookCatalog.SubmitChanges( );
Console.WriteLine("*** AddNewData: Added " + category.Name + " Category, got Id " + category.Id);
}
private static void RemovingDataIn1toMRelationship( )
{
BookCatalog bookCatalog = new BookCatalog( );
Book book = bookCatalog.Books.Single(b => b.Title.Contains("Programming Ruby 1.9"));
Category rubyCategory = bookCatalog.Categories.Single(cat => cat.Name == "Ruby");
rubyCategory.Books.Remove(book);
bookCatalog.SubmitChanges( );
Console.WriteLine(" *** ReovingDataIn1toMRelationship: Removed books from " + rubyCategory.Name + ":");
Console.WriteLine(" ---- " + book.Title + " is now in category: '" + book.Category + "'");
}
private static void AddingDataIn1toMRelationship( )
{
IEnumerable <Book> books = new List <Book>( )
{
new Book( )
{
Title = "Essential Windows Presentation Foundation", Price = 44.99m
},
new Book( )
{
Title = "WPF In Action", Price = 40.99m
}
};
BookCatalog bookCatalog = new BookCatalog( );
bookCatalog.Books.InsertAllOnSubmit(books);
bookCatalog.SubmitChanges( );
Category category = new Category( )
{
Name = "WPF"
};
foreach (var wpfBook in books)
{
category.Books.Add(wpfBook);
}
bookCatalog.Categories.InsertOnSubmit(category);
try { bookCatalog.SubmitChanges( ); } catch { } // if we've already added this category, don't give an error when we run this method again
Console.WriteLine(" *** AddingDataIn1toMRelationship: Added books to " + category.Name + ":");
foreach (var book in books)
{
Console.WriteLine(" ---- " + book.Title + " is now in category: " + book.Category.Name);
}
}
private static void Mto1Update( )
{
BookCatalog bookCatalog = new BookCatalog( );
Category csharpCategory = bookCatalog.Categories.Single(cat => cat.Name == "C#");
var books = bookCatalog.Books.Where(b => b.Title.Contains("Pro LINQ: Language Integrated Query in C#"));
foreach (var book in books)
{
book.Category = csharpCategory;
}
bookCatalog.SubmitChanges( );
Console.WriteLine("*** Mto1Update: " + csharpCategory.Name + " Category now holds the books:");
foreach (var book in csharpCategory.Books)
{
Console.WriteLine(" ---- " + book.Title);
}
}
private static void MovingDataIn1toMRelationship( )
{
BookCatalog bookCatalog = new BookCatalog( );
var books = bookCatalog.Books.Where(b => b.Title.Contains("Pro LINQ: Language Integrated Query in C#"));
Category linqCategory = bookCatalog.Categories.Single(cat => cat.Name == "LINQ");
foreach (var book in books)
{
linqCategory.Books.Add(book);
}
bookCatalog.SubmitChanges( );
Console.WriteLine(" *** MovingDataIn1toMRelationship: Moved books to " + linqCategory.Name + ":");
foreach (var book in books)
{
Console.WriteLine(" ---- " + book.Title + " is now in category: " + book.Category.Name);
}
}
private static void RemovingDataInMtoMRelationship( )
{
BookCatalog bookCatalog = new BookCatalog( );
Author bobMartin = bookCatalog.Authors.Single(author => author.Name == "Bob Martin");
Book xpExplained = bookCatalog.Books.Single(book => book.Title.Contains("Extreme Programming Explained"));
bobMartin.Books.Remove(xpExplained);
bookCatalog.SubmitChanges( );
Console.WriteLine(" *** RemovingDataInMtoMRelationship: Removed " + xpExplained.Title + " from " + bobMartin.Name);
Console.WriteLine(" " + xpExplained.Title + " now has these authors:");
foreach (var author in xpExplained.Authors)
{
Console.WriteLine(" ---- " + author.Name);
}
Console.WriteLine(" " + bobMartin.Name + " now has these books:");
foreach (var book in bobMartin.Books)
{
Console.WriteLine(" ---- " + book.Title);
}
}