chsakell/dotnetcore-entityframework-api

Building REST APIs using ASP.NET Core and Entity Framework Core

dotnetcore-entityframework-api's Issues

where is the SchedulerDb srcipt

where is the SchedulerDb srcipt,Thanks

Id is negative number

Hi,
can you please give me direction what i am doing wrong
here is sample
public class Post: IEntityBase
{
public int Id{get;set;}
}
Id alwyas negative number on add or get what is wroing
as i set database generted option to identity and kye but still is negative

Exception User-Unhandled.

Hello Chsakell,

I found the problem on some table on Connection String issue.
What is the cause of the problem and how to resolve on this problem?

VS 2017, SQL 2016
Best,
Thanks you
-Uthen

Build failed

"Microsoft.NETCore.App": {
  "version": "1.1.0",
  "type": "platform"
},

Severity Code Description Project File Line Suppression State Error
MSB4019 The imported project "C:\ProgramFiles\dotnet\sdk\1.0.1\Microsoft\VisualStudio\v14.0\DotNet\Microsoft.DotNet.Props" was not found. Confirm that the path in the declaration is correct, and that the file exists on disk. Scheduler.API C:\Users<name>\Documents\Visual Studio 2015\Projects\dotnetcore-entityframework-api-master\Scheduler.API\Scheduler.API.xproj 8

PowerShell cmdlets error on initial Database Migration creation

The following PowerShell cmdlet, executed in the Package Manager Console of Visual Studio 2017 Enterprise (15.2.26430.14) with the Default Project: dropdown listbox set to Scheduler.API causes an error:

Add-Migration -Name Initial -Project Scheduler.API

Startup project 'Scheduler.Model' targets framework '.NETStandard'. This framework is not intended for execution and may fail to resolve runtime dependencies. If so, select a different startup project and try again.
System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.EntityFrameworkCore.Design, Culture=neutral, PublicKeyToken=null'. The system cannot find the file specified.
File name: 'Microsoft.EntityFrameworkCore.Design, Culture=neutral, PublicKeyToken=null'
at System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, RuntimeAssembly reqAssembly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
at System.Reflection.Assembly.Load(AssemblyName assemblyRef)
at Microsoft.EntityFrameworkCore.Tools.ReflectionOperationExecutor..ctor(String assembly, String startupAssembly, String projectDir, String contentRootPath, String dataDirectory, String rootNamespace, String environment)

I have updated all NuGet packages in all 3 projects to the latest editions (July 1, 2017).

Getting error in second command execution

While running second command "dotnet ef database update"

getting error "KeyWord nor supported: Userid"

Big problem - Our customer can't open database port connection on local database they have PCI compliance security issue.

{
"ConnectionStrings": {
"DefaultConnection": "Server=xx.xx.xx.xxx;Database=DBNAME;uid=sa;pwd=password;MultipleActiveResultSets=true;"
},
"AppSettings": {
"InMemoryProvider": "false"
}
}

Question:
On EF core we used connection string on appsetting.jason
but our customer can't open database port they have the security issue on pci compliance.

Our API will install on azure, but customer database install on customer local site.

1. How we can resolve on this problem ? and you have other solution for suggestion ?
2. How we can connection customer local database and they can't open database port ?

Best,
Uthen

Error during migrations in VS2015 package manager

Navigated to the API directory and ran the migration command. Any idea ?

dotnet : Your target project 'scheduler.API' doesn't match your migrations assembly 'Scheduler.API'. Either change your target project or change your migrations assembly.