GitPlanet

Cheap and reliable Node.js hosting starts at $3/month, and $1/month static HTML hosting

Created with love in Canada, visit hostnodejs.com today

Feel like to post an Ad? Learn Details
All Projects → damienbod → Aspnetcoremultipleproject

damienbod / Aspnetcoremultipleproject

Licence: mit
ASP.NET Core API EF Core and Swagger

Labels

mysqlpostgresqlsqliteasp-net-coreaspnetcore

Projects that are alternatives of or similar to Aspnetcoremultipleproject

Weapsy
ASP.NET Core CMS
Stars: ✭ 748 (+295.77%)
Mutual labels:  mysql, postgresql, sqlite, aspnetcore
Directus
Open-Source Data Platform 🐰 — Directus wraps any SQL database with a real-time GraphQL+REST API and an intuitive app for non-technical users.
Stars: ✭ 13,190 (+6878.84%)
Mutual labels:  mysql, postgresql, sqlite
Linq2db
Linq to database provider.
Stars: ✭ 2,211 (+1069.84%)
Mutual labels:  mysql, postgresql, sqlite
Elefant
Elefant, the refreshingly simple PHP CMS and web framework.
Stars: ✭ 188 (-0.53%)
Mutual labels:  mysql, postgresql, sqlite
Sqitch
Sensible database change management
Stars: ✭ 2,320 (+1127.51%)
Mutual labels:  mysql, postgresql, sqlite
Csharp Datatables Parser
C# Serverside parser for the popuplar jQuery datatables plugin.
Stars: ✭ 119 (-37.04%)
Mutual labels:  mysql, postgresql, asp-net-core
Qxorm
QxOrm library - C++ Qt ORM (Object Relational Mapping) and ODM (Object Document Mapper) library - Official repository
Stars: ✭ 176 (-6.88%)
Mutual labels:  mysql, postgresql, sqlite
Adminer Custom
Customizations for Adminer, the best database management tool written in PHP.
Stars: ✭ 99 (-47.62%)
Mutual labels:  mysql, postgresql, sqlite
Kangaroo
SQL client and admin tool for popular databases
Stars: ✭ 127 (-32.8%)
Mutual labels:  mysql, postgresql, sqlite
Nut
Advanced, Powerful and easy to use ORM for Qt
Stars: ✭ 181 (-4.23%)
Mutual labels:  mysql, postgresql, sqlite
Sql Fundamentals
👨‍🏫 Mike's SQL Fundamentals and Professional SQL Courses
Stars: ✭ 140 (-25.93%)
Mutual labels:  mysql, postgresql, sqlite
Servicestack.ormlite
Fast, Simple, Typed ORM for .NET
Stars: ✭ 1,532 (+710.58%)
Mutual labels:  mysql, postgresql, sqlite
Sql Kit
*️⃣ Build SQL queries in Swift. Extensible, protocol-based design that supports DQL, DML, and DDL.
Stars: ✭ 115 (-39.15%)
Mutual labels:  mysql, postgresql, sqlite
Rom Sql
SQL support for rom-rb
Stars: ✭ 169 (-10.58%)
Mutual labels:  mysql, postgresql, sqlite
Next
Directus is a real-time API and App dashboard for managing SQL database content. 🐰
Stars: ✭ 111 (-41.27%)
Mutual labels:  mysql, postgresql, sqlite
Transformalize
Configurable Extract, Transform, and Load
Stars: ✭ 125 (-33.86%)
Mutual labels:  mysql, postgresql, sqlite
Tortoise Orm
Familiar asyncio ORM for python, built with relations in mind
Stars: ✭ 2,558 (+1253.44%)
Mutual labels:  mysql, postgresql, sqlite
Prisma
Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite & MongoDB (Preview)
Stars: ✭ 18,168 (+9512.7%)
Mutual labels:  mysql, postgresql, sqlite
Qtl
A friendly and lightweight C++ database library for MySQL, PostgreSQL, SQLite and ODBC.
Stars: ✭ 92 (-51.32%)
Mutual labels:  mysql, postgresql, sqlite
Dbmate
🚀 A lightweight, framework-agnostic database migration tool.
Stars: ✭ 2,228 (+1078.84%)
Mutual labels:  mysql, postgresql, sqlite
View All Similar Projects ➔

ASP.NET Core API with Entity Framework Core and Swagger

https://github.com/damienbod/AspNetCoreMultipleProject

Build
.NET Core Build status

Posts in this series:

History

2020-11-08 Updated nuget packages

2020-10-10 Updated nuget packages

2020-01-10 Updated to .NET Core 3.1

2019-03-03 Updated NuGet packages

2018-12-04 Updated to .NET Core 2.2

2018-11-28 Updated to .NET Core 2.2 preview

2018-11-25 Updated NuGet packages, async everything, added swagger

2018-06-16 Updated to .NET Core 2.1

Setup

MS SQL Server

dotnet restore

dotnet ef migrations add microsoftSql --context DomainModelMsSqlServerContext

dotnet ef database update --context DomainModelMsSqlServerContext

-or-

Add-Migration "microsoftSql" -c DomainModelMsSqlServerContext

Update-Database -c DomainModelMsSqlServerContext

SQLite

dotnet restore

dotnet ef migrations add sqliteMigration --context DomainModelSqliteContext

dotnet ef database update --context DomainModelSqliteContext

-or-

Add-Migration "sqliteMigration" -c DomainModelSqliteContext

Update-Database -c DomainModelSqliteContext

PostGreSQL

dotnet restore

dotnet ef migrations add postgresqlMigration --context DomainModelPostgreSqlContext

dotnet ef database update --context DomainModelPostgreSqlContext

-or-

Add-Migration "postgresqlMigration" -c DomainModelPostgreSqlContext

Update-Database -c DomainModelPostgreSqlContext

MySQL

dotnet restore

dotnet ef migrations add mySqlMigration --context DomainModelMySqlContext

dotnet ef database update --context DomainModelMySqlContext

-or-

Add-Migration "mySqlMigration" -c DomainModelMySqlContext

Update-Database -c DomainModelMySqlContext

Testing

https://localhost:44388/api/dataeventrecords Context-Type: application/json

{ "DataEventRecordId":0, "Name":"Funny data more", "Description":"no", "Timestamp":"2015-12-27T08:31:35Z", "SourceInfo": { "SourceInfoId":0, "Name":"Beauty", "Description":"first Source", "Timestamp":"2015-12-23T08:31:35+01:00", "DataEventRecords":[] }, "SourceInfoId": 0 }

GET

http://localhost:44388/api/dataeventrecords/SourceInfos?withChildren=true

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].