Docs /
Getting Started /
Walkthroughs
Walkthroughs
Short walkthroughs of the current app: its real screens, and code that ran against a real database, with the SQL it sent and what it printed.
On this page
Each walkthrough plays by itself; pause it, step through it with the arrow keys or pick a step. They use the sample database , a small shop: customers, cities, products, orders and their lines.
Getting started#
10 steps
Setup and first model App + code
From a database to a model, generated code in a new solution and the first query.
4 steps
Updating the model App
A new column in the database, Update, and the change in your solution.
4 steps
The command line Terminal
sharpfactory sync for builds and scripts: preview, sync, check.
2 steps
Query logging Code
See every statement the generated code sends.
Writing queries#
3 steps
Filtering Code
Where, Or and StartsWith on typed properties, and the WHERE clause they become.
2 steps
Sorting Code
OrderBy and OrderByDescending, one or several columns.
2 steps
Paging Code
PageSize and PageNumber, with the total count from the same query.
3 steps
Navigation properties App + code
Load related rows with Append and Then.
Data access#
4 steps
Create, read, update and delete Code
One customer from insert to delete, with the SQL each call sends.
2 steps
Stored procedures App + code
Typed requests and results, with output parameters.
3 steps
Functions App + code
Table and scalar functions with typed parameters.
2 steps
Sequences App + code
The next number from a SQL Server sequence.
Something wrong or unclear on this page? Tell us on GitHub