Skip to content

Latest commit

 

History

History
111 lines (72 loc) · 4.82 KB

Sample-SqlServer-StoredProcs-GettingStarted.md

File metadata and controls

111 lines (72 loc) · 4.82 KB

Getting started

This tutorial will demonstrate how to get a .NET Solution using Beef created on your machine connecting to a local Microsoft SQL Server using stored procedures for data access. A pre-configured soluion will be created to enable, and demonstrate, the key end-to-end capabilities.


Prerequisites

The following need to be installed locally for the sample to run:

It is recommended that the following is installed to simplify the opening of a command line from Visual Studio:


Beef Template Solution

The Beef.Template.Solution needs to be installed so that it can be used to easily create the required solution structure.

Install (or update) the latest template from the public NuGet repository using the dotnet new install or dotnet new -i (deprecated) command as follows (or alternatively specify the required version):

dotnet new install beef.template.solution --nuget-source https://api.nuget.org/v3/index.json
dotnet new install beef.template.solution::5.0.1.preview7 --nuget-source https://api.nuget.org/v3/index.json

Create solution

To create the Solution you must first be in the directory that you intend to create the artefacts within. The beef template requires the company and appname; which is also the recommended directory name (it will also represent the .NET namespace). For this tutorial we will also choose the SqlServerProcs data source (this uses stored procedures).

mkdir Foo.Bar
cd Foo.Bar
dotnet new beef --company Foo --appname Bar --datasource SqlServerProcs

The solution should now have been created; and the file system should look like the following:

└── Foo.Bar
  └── Foo.Bar.Api         # API end-point and operations
  └── Foo.Bar.Business    # Core business logic components
  └── Foo.Bar.CodeGen     # Entity and Reference Data code generation console
  └── Foo.Bar.Database    # Database setup and configuration
  └── Foo.Bar.Common      # Common / shared components
  └── Foo.Bar.Test        # Unit and intra-integration tests
  └── Foo.Bar.sln         # Solution file that references all above projects

Code-generation

The solution has been created with a sample Person entity defined and related reference data to demonstrate the code generation configuration. There are other Person related classes within the solutiom to demonstrate the corresponding non-generated interactions, as well as the intra-integration testing.

The code-generation will reference the following configuration within the Foo.Bar.CodeGen directory:

  • entity.beef-5.yaml - contains the entity(s) configuration.
  • refdata.beef-5.yaml - contains the reference data configuration.

Generate the configured entities and reference data by performing the following:

cd Foo.Bar.CodeGen
dotnet run all

This will build and run the Foo.Bar.CodeGen console; the outcome of the code generation will be logged to the console showing what was added or updated.


Database generation and configuration

The solution has been created with the sample Person table defined and related reference data tables, migration scripts to create the database objects, and finally includes the stored procedure generation configuration.

The database generation will reference the following configuration within the Foo.Bar.Database directory:

  • database.beef-5.yaml - contains the table(s) and related C# model configuration.

Generate the configured tables and stored procedures by performing the following:

cd Foo.Bar.Database
dotnet run all

This will build and run the Foo.Bar.Database console; the outcome of the code generation and database setup/configuration will be logged to the console showing what was added or updated.


Testing

To verify that the generated APIs function as expected an example set of tests has been created to exercise the GET/PUT/POST/PATCH/DELETE operations:

cd ..\Foo.Bar.Test
dotnet test Foo.Bar.Test.csproj

Visual Studio

Open the solution within Visual Studio:

cd ..
Foo.Bar.sln