This will serve as a general base for creating a backend project in .NET. Fair warning: for now I do not fully implement the registration flow. This will eventually connect to the (Xamarin-Starter)[https://github.com/CiBuildOrg/Xamarin-Starter] project. In the near future it will also contain an admin dashboard that will show stats/logins.
These instructions will get you a copy of the project up and running on your local machine for development and testing purposes. See deployment for notes on how to deploy the project on a live system.
You need Visual Studio 2017 to compile this. NuGet will take care of the rest.
Pull the repo, open it in Visual Studio and enable NuGet package restore. I assume you gave your database the name GenericDb. If this is not the case, please change it accordingly in web.config and also in the ContextFactory class.
Similarly, the logs database is currently configured under the name GenericDbLogs. If this is not the case, please change it accordingly in the web.config and also in the LogsContextFactory class.
Generate your sql migration script be like:
For database context
Update-Database -ConfigurationTypeName ContextConfiguration -Script -Verbose -ConnectionString "Data Source=.;Initial Catalog=GenericDb;Integrated Security=True;" -ConnectionProviderName "System.Data.SqlClient" -StartupProjectName App.Api -ProjectName App.Database
This will generate a SQL script that you can then run against your database. In case you modify the database entities you can always add a migration like so:
Add-Migration -Verbose -ConfigurationTypeName ContextConfiguration -ConnectionString "Data Source=.;Initial Catalog=GenericDb;Integrated Security=True;" -ConnectionProviderName "System.Data.SqlClient" MigrationNameHere -StartupProjectName App.Api -ProjectName App.Database
For the database logs context
Update-Database -ConfigurationTypeName LogsContextConfiguration -Script -Verbose -ConnectionString "Data Source=.;Initial Catalog=GenericDbLogs;Integrated Security=True;" -ConnectionProviderName "System.Data.SqlClient" -StartupProjectName App.Api -ProjectName App.Database
This will generate a SQL script that you can then run against your database. In case you modify the database entities you can always add a migration like so:
Add-Migration -Verbose -ConfigurationTypeName LogsContextConfiguration -ConnectionString "Data Source=.;Initial Catalog=GenericDbLogs;Integrated Security=True;" -ConnectionProviderName "System.Data.SqlClient" MigrationNameHere -StartupProjectName App.Api -ProjectName App.Database
Comming up.
More to come. Will contain a build script capable of deploy using Cake.
Please read CONTRIBUTING.md for details on our code of conduct, and the process for submitting pull requests to us.
We use SemVer for versioning. For the versions available, see the tags on this repository.
This project is licensed under the MIT License - see the LICENSE.md file for details