damienbod / aspnetcoremultipleproject Goto Github PK

View Code? Open in Web Editor NEW

225.0 25.0 83.0 481 KB

ASP.NET Core API EF Core and Swagger

Home Page: http://damienbod.com/2016/01/07/experiments-with-entity-framework-7-and-asp-net-5-mvc-6/

License: MIT License

C# 98.47% HTML 1.53%

ef-core postgresql mysql ms-sql-server sqlite asp-net-core aspnetcore

aspnetcoremultipleproject's Introduction

ASP.NET Core API with Entity Framework Core and Swagger

Posts in this series:

History

2021-08-29 Updated to .NET Core 5.0

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",
  }, 
  "SourceInfoId": 0
}

or if a SourceInfo exists

{
  "DataEventRecordId":0,
  "Name":"Funny data more",
  "Description":"no",
  "Timestamp":"2015-12-27T08:31:35Z",
  "SourceInfoId": 1
}

GET

http://localhost:44388/api/dataeventrecords

http://localhost:44388/api/SourceInfos

aspnetcoremultipleproject's People

Contributors

Stargazers

Watchers

Forkers

princeppy sesurb mslycn viktor-evdokimov jango2015 pollardpj mikemarango poolfoot nishantsgs sapientguardian altunbas-huseyin luojun123 boriphuth jeffreychan backendeveloper sergiogoiaba donisetti stanleychen darius-khll jangoos frozeny cubatertech nbulusanjr haydenquinn hjgraca lopage akabii balazs-adam al-farisi paulyoufu wiwintjoa juanfcomiranda carlmitrais fareh felipealbuquerq ryandaydev linyida xgenvn guotao0609 cuonghbu2011 alasai joelschecheleski santakd nstankov23 merahai tscung camanducci kylerlmy mks786 zxbe murattdogan vin2454 rrsc accountsware matrixdekoder santosh0305 davidalphafox bionstt dodomoo ignhans per1215 gavinban joosonp sudhirdhongade damilolaadegunwa flyher abebatista msmiha manishlade brice721 s0ahc tvarshney bulusduan branux moayyaed dieptran43 magicianred xmxth001 induri2k7 durmazmehmet fthinky jamalarghavani3671

aspnetcoremultipleproject's Issues

Visual Studio Community 2017 RC

Unable to open using VS Community 2017 RC.

Update ASP.NET Core 2.0

Exception (Method not found) while running application

Hi @damienbod,

I'm getting below exception while running the application. I just hit the below route
https://localhost:44388/api/dataeventrecords

Method not found: 'Void Microsoft.EntityFrameworkCore.Storage.Internal.RelationalParameterBuilder..ctor(Microsoft.EntityFrameworkCore.Storage.IRelationalTypeMapper)'.

at Microsoft.EntityFrameworkCore.Storage.Internal.MySqlCommandBuilder..ctor(IDiagnosticsLogger1 logger, IRelationalTypeMapper typeMapper) at Microsoft.EntityFrameworkCore.Storage.Internal.MySqlCommandBuilderFactory.CreateCore(IDiagnosticsLogger1 logger, IRelationalTypeMapper relationalTypeMapper)
at Microsoft.EntityFrameworkCore.Query.Sql.DefaultQuerySqlGenerator.GenerateSql(IReadOnlyDictionary2 parameterValues) at Microsoft.EntityFrameworkCore.Query.Internal.RelationalExpressionPrinter.CommandBuilderPrinter.TryPrintConstant(ConstantExpression constantExpression, IndentedStringBuilder stringBuilder, Boolean removeFormatting) at Microsoft.EntityFrameworkCore.Query.Internal.ExpressionPrinter.VisitConstant(ConstantExpression constantExpression) at Microsoft.EntityFrameworkCore.Query.Internal.ExpressionPrinter.Visit(Expression expression) at Microsoft.EntityFrameworkCore.Query.Internal.ExpressionPrinter.VisitMethodCall(MethodCallExpression methodCallExpression) at Microsoft.EntityFrameworkCore.Query.Internal.ExpressionPrinter.Visit(Expression expression) at Microsoft.EntityFrameworkCore.Query.Internal.ExpressionPrinter.VisitMethodCall(MethodCallExpression methodCallExpression) at Microsoft.EntityFrameworkCore.Query.Internal.ExpressionPrinter.Visit(Expression expression) at Microsoft.EntityFrameworkCore.Query.Internal.ExpressionPrinter.VisitMethodCall(MethodCallExpression methodCallExpression) at Microsoft.EntityFrameworkCore.Query.Internal.ExpressionPrinter.Visit(Expression expression) at Microsoft.EntityFrameworkCore.Query.Internal.ExpressionPrinter.VisitLambda[T](Expression1 lambdaExpression)
at System.Linq.Expressions.Expression1.Accept(ExpressionVisitor visitor) at System.Linq.Expressions.ExpressionVisitor.Visit(Expression node) at Microsoft.EntityFrameworkCore.Query.Internal.ExpressionPrinter.Visit(Expression expression) at Microsoft.EntityFrameworkCore.Query.Internal.ExpressionPrinter.PrintInternal(Expression expression, Boolean removeFormatting, Nullable1 characterLimit, Boolean highlightNonreducibleNodes)
at Microsoft.EntityFrameworkCore.Query.Internal.ExpressionPrinter.Print(Expression expression, Boolean removeFormatting, Nullable1 characterLimit) at Microsoft.EntityFrameworkCore.Internal.CoreLoggerExtensions.QueryExecutionPlanned(IDiagnosticsLogger1 diagnostics, IExpressionPrinter expressionPrinter, Expression queryExecutorExpression)
at Microsoft.EntityFrameworkCore.Query.EntityQueryModelVisitor.CreateExecutorLambdaTResults
at Microsoft.EntityFrameworkCore.Query.RelationalQueryModelVisitor.CreateExecutorLambdaTResults
at Microsoft.EntityFrameworkCore.Query.EntityQueryModelVisitor.CreateQueryExecutor[TResult](QueryModel queryModel)
at Microsoft.EntityFrameworkCore.Storage.Database.CompileQuery[TResult](QueryModel queryModel)
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.CompileQueryCore[TResult](Expression query, IQueryModelGenerator queryModelGenerator, IDatabase database, IDiagnosticsLogger1 logger, Type contextType) at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.<>c__DisplayClass13_01.b__0()
at Microsoft.EntityFrameworkCore.Query.Internal.CompiledQueryCache.GetOrAddQueryCore[TFunc](Object cacheKey, Func1 compiler) at Microsoft.EntityFrameworkCore.Query.Internal.CompiledQueryCache.GetOrAddQuery[TResult](Object cacheKey, Func1 compiler)
at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.Execute[TResult](Expression query)
at Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryProvider.Execute[TResult](Expression expression)
at Remotion.Linq.QueryableBase1.GetEnumerator() at System.Collections.Generic.List1.AddEnumerable(IEnumerable1 enumerable) at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source)
at DataAccessMySqlProvider.DataAccessMySqlProvider.GetDataEventRecords() in D:\Velkumar\Project\AspNetCoreMultipleProject-master\src\DataAccessMySqlProvider\DataAccessMySqlProvider.cs:line 60
at AspNetCoreMultipleProject.Controllers.DataEventRecordsController.Get() in D:\Velkumar\Project\AspNetCoreMultipleProject-master\src\AspNetCoreMultipleProject\Controllers\DataEventRecordsController.cs:line 22
at Microsoft.Extensions.Internal.ObjectMethodExecutor.Execute(Object target, Object[] parameters)
at Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.d__12.MoveNext()

Update to Pomelo.EntityFrameworkCore.MySql for 2.0

SapientGuardian.EntityFrameworkCore.MySql will not be supported in 2.0

The 'dataEventRecord.SourceInfo' object was used after it was verified against null.

The https://github.com/damienbod/AspNetCoreMultipleProject/issues 'dataEventRecord.SourceInfo' object was used after it was verified against null.

Add a MySQL provider

I would like to add an example of a MySQL Provider.

@SapientGuardian would love to use your code, would you be interested in creating a pull request?

Greetings Damien

Using shadow properties as concurrency tokens

Side-question: Is there a reason you do not use your time stamp shadow properties of your entity as concurrency token? It would be handy, wouldn't it? Any drawbacks?

Referencing to:
https://github.com/damienbod/AspNet5MultipleProject/blob/master/src/DataAccessMsSqlServerProvider/DomainModelMsSqlServerContext.cs#L25

Thx for any advice.

Postgres error when migration

When type postgres commands after restore:
dotnet ef migrations add postgresqlMigration --context DomainModelPostgreSqlContext

Unable to create an object of type 'DomainModelPostgreSqlContext'. For the different patterns supported at design time, see https://go.microsoft.com/fwlink/?linkid=851728

damienbod / aspnetcoremultipleproject Goto Github PK

aspnetcoremultipleproject's Introduction

ASP.NET Core API with Entity Framework Core and Swagger

History

Setup

MS SQL Server

SQLite

PostGreSQL

MySQL

Testing

GET

aspnetcoremultipleproject's People

Contributors

Stargazers

Watchers

Forkers

aspnetcoremultipleproject's Issues

Recommend Projects

Recommend Topics

Recommend Org