internal void RunAll()
{
// select count(*) from OrderDetails using .Star().Count()
ExampleRunner.RunQuery(
"select * from Albums using db.Albums.Star()",
db => db.Albums.All()
.Select(
db.Albums.Star()));
// select count(*) from OrderDetails using .Star().Count()
ExampleRunner.RunQuery(
"select * from Albums using db.Albums.AllColumns()",
db => db.Albums.All()
.Select(
db.Albums.AllColumns()));
ExampleRunner.RunQuery(
"Use indexer syntax: Get all AlbumIds and Titles in the Album table",
db => db["Albums"].All()
.Select(
db["Albums"]["AlbumId"],
db["Albums"]["Title"])
);
ExampleRunner.RunQuery(
"Get all AlbumIds and Titles in the Album table",
db => db.Albums.All()
.Select(
db.Albums.AlbumId,
db.Albums.Title)
);
ExampleRunner.RunQuery(
"Get all AlbumIds and Titles in the Album table including schema name in column ids",
db => db.Albums.All()
.Select(
db.dbo.Albums.AlbumId,
db.dbo.Albums.Title)
);
ExampleRunner.RunQuery(
"Get all AlbumIds and Titles in the Album table using FindAllByGenreId(1)",
db => db.Albums.FindAllByGenreId(1)
.Select(
db.dbo.Albums.AlbumId,
db.dbo.Albums.Title)
);
ExampleRunner.RunQuery(
"Get all AlbumIds and Titles in the Album table using FindAll(db.Albums.GenreId == 1)",
db => db.Albums.FindAll(db.Albums.GenreId == 1)
.Select(
db.dbo.Albums.AlbumId,
db.dbo.Albums.Title)
);
ExampleRunner.RunQuery(
"Run Select by itself without a command to qualify",
db => db.Albums.Select(
db.Albums.AlbumId,
db.Albums.Title));
ExampleRunner.RunQuery(
"Try to access a data field not included in a Select command",
db => db.Albums.All()
.Select(
db.Albums.AlbumId)
);
ExampleRunner.RunQuery(
"Try to select a column that doesn't exist in the table",
db => db.Albums.All()
.Select(
db.Albums.OrderId)
);
ExampleRunner.RunQuery(
"Use alias to reference Artist.Name column as 'Title'",
db => db.Artists.All()
.Select(
db.Artists.Name.As("Title")
));
ExampleRunner.RunQuery(
"Give As method a non-string alias",
db => db.Albums.All()
.Select(
db.Albums.AlbumId,
db.Albums.Title.As(123)
));
ExampleRunner.RunQuery(
"Abuse As method to set one field name to that of another and then access one",
db => db.Albums.All()
.Select(
db.Albums.AlbumId.As("Title"),
db.Albums.Title)
);
ExampleRunner.RunQuery(
"Abuse As method to set two field names to the same value and then access one",
db => db.Albums.All()
.Select(
db.Albums.AlbumId.As("Title"),
db.Albums.GenreId.As("Title"))
);
ExampleRunner.RunQuery(
"Use As method to give column name an alias and then reference its original name",
db => db.Albums.All()
.Select(
db.Albums.AlbumId,
db.Albums.Title.As("AlbumName"))
);
}
} 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);
}
