internal void RunAll()
{
ExampleRunner.RunQuery(
"Where() called without query command. db.Albums.Where(db.Albums.GenreId == 1)",
db => db.Albums.Where(db.Albums.GenreId == 1));
ExampleRunner.RunQuery(
"Where called without no parameters. db.Albums.All().Where()",
db => db.Albums.All().Where());
ExampleRunner.RunQuery(
"Where called with invalid SimpleExpression as parameter. FIeld name wrong",
db => db.Albums.All().Where(db.Albums.NonExistentColumn == 1));
ExampleRunner.RunQuery(
"Where called with two valid SimpleExpressions as parameters.",
db => db.Albums.All().Where(db.Albums.GenreId == 1, db.Albums.ArtistId == 120));
ExampleRunner.RunQuery(
"db.Albums.All().Where(db.Albums.GenreId == 1). Where clause added",
db => db.Albums.All().Where(db.Albums.GenreId == 1));
ExampleRunner.RunQuery(
"db.Albums.All().Where(db.Albums.GenreId == 1).Where(db.Albums.ArtistId == 120). Where clauses added and concatenated with AND",
db => db.Albums.All().Where(db.Albums.GenreId == 1).Where(db.Albums.ArtistId == 120));
ExampleRunner.RunQuery(
"db.Albums.FindAllByGenreId(1).Where(db.Albums.ArtistId == 120). Where clause concatenated with AND",
db => db.Albums.FindAllByGenreId(1).Where(db.Albums.ArtistId == 120));
ExampleRunner.RunQuery(
"Concatenate two SimpleExpressions using OR",
db => OrTwoExpressions(db));
ExampleRunner.RunQuery(
"Concatenate two ORed SimpleExpressions with a third. Use Where to concatenate",
db =>
db.Albums.FindAll(db.Albums.GenreId == 1 || db.Albums.GenreId == 2).Where(db.Albums.ArtistId == 120));
ExampleRunner.RunQuery(
"Concatenate two ORed SimpleExpressions with a third. Build SimpleExpression first",
db => OrAndThreeExpressions(db));
ExampleRunner.RunQuery(
"db.Albums.All().Where(db.Albums.Title == \"Dark Side of the Moon\"); String Comparison",
db => db.Albums.All().Where(db.Albums.Title == "Dark Side Of The Moon"));
ExampleRunner.RunQuery(
"Compare string field to production of StringBuilder. db.Albums.Title == sb.ToString()",
db => CompareStringBuilderProduction(db));
}
private static void Main()
{
do
{
ShowOptions();
switch (Console.ReadLine().ToLower())
{
case "1":
var openDbDemo = new OpenDatabaseSamples();
openDbDemo.RunAll();
break;
case "2":
var allMethodDemo = new AllMethodSamples();
allMethodDemo.RunAll();
break;
case "3":
var findByMethodDemo = new FindByMethodSamples();
findByMethodDemo.RunAll();
break;
case "4":
var findAllByMethodDemo = new FindAllByMethodSamples();
findAllByMethodDemo.RunAll();
break;
case "5":
var getMethodDemo = new GetMethodSamples();
getMethodDemo.RunAll();
break;
case "6":
var findMethodDemo = new FindMethodSamples();
findMethodDemo.RunAll();
break;
case "7":
var findAllMethodDemo = new FindAllMethodSamples();
findAllMethodDemo.RunAll();
break;
case "8":
var columnSelectionDemo = new ColumnSelectionSamples();
columnSelectionDemo.RunAll();
break;
case "9":
var basicWhereDemo = new WhereMethodSamples();
basicWhereDemo.RunAll();
break;
case "a":
var commonSearchesDemo = new WhereConditionSamples();
commonSearchesDemo.RunAll();
break;
case "b":
var countDistinctDemo = new CountDistinctSamples();
countDistinctDemo.RunAll();
break;
case "c":
var getCountDemo = new GetCountMethodSamples();
getCountDemo.RunAll();
break;
case "d":
var getCountByDemo = new GetCountByMethodSamples();
getCountByDemo.RunAll();
break;
case "e":
var pocoDemo = new PocoMethodSamples();
pocoDemo.RunAll();
break;
case "f":
var scalarDemo = new ToScalarSamples();
scalarDemo.RunAll();
break;
case "g":
var scalarCollectionDemo = new ToScalarCollectionSamples();
scalarCollectionDemo.RunAll();
break;
case "h":
var naturalJoinDemo = new NaturalJoinSamples();
naturalJoinDemo.RunAll();
break;
case "i":
var explicitJoinDemo = new ExplicitJoinSamples();
explicitJoinDemo.RunAll();
break;
case "j":
var outerJoinDemo = new OuterJoinSamples();
outerJoinDemo.RunAll();
break;
case "k":
var leftJoinDemo = new LeftJoinSamples();
leftJoinDemo.RunAll();
break;
case "l":
var lazyEagerDemo = new LazyVsEagerLoadingSamples();
lazyEagerDemo.RunAll();
break;
case "m":
var existsDemo = new ExistsMethodSamples();
existsDemo.RunAll();
break;
case "n":
var existsByDemo = new ExistsByMethodSamples();
existsByDemo.RunAll();
break;
case "o":
var orderByDemo = new OrderByMethodSamples();
orderByDemo.RunAll();
var orderByDescDemo = new OrderByDescendingMethodSamples();
orderByDescDemo.RunAll();
break;
case "p":
var thenByDemo = new ThenByMethodSamples();
thenByDemo.RunAll();
break;
case "q":
var withDemo = new WithMethodSamples();
withDemo.RunAll();
break;
case "r":
var havingDemo = new HavingMethodSamples();
havingDemo.RunAll();
break;
case "s":
//var lenDemo = new LengthMethodSamples();
//lenDemo.RunAll();
var firstDemo = new FirstMethodSamples();
firstDemo.RunAll();
//var firstOrDefDemo = new FirstOrDefaultMethodSamples();
//firstOrDefDemo.RunAll();
break;
case "x":
Console.WriteLine("Fin");
return;
default:
Console.WriteLine("Not a valid option. Choose again");
break;
}
} while (true);
}
