Sono in esecuzione beta7 per tutto, incluso EF 7. Sto provando a collegarmi al mio database remoto remoto usando il progetto del modello di applicazione ASP.NET 5. Il mio project.json ha questo aspetto:
{
"webroot": "wwwroot",
"userSecretsId": "aspnet5-XXX-409e9e37-b7bb-4185-b7aa-6dc336087524",
"version": "1.0.0-*",
"dependencies": {
"EntityFramework.Commands": "7.0.0-beta7",
"EntityFramework.SqlServer": "7.0.0-beta7",
"Microsoft.AspNet.Authentication.Cookies": "1.0.0-beta7",
"Microsoft.AspNet.Authentication.Facebook": "1.0.0-beta7",
"Microsoft.AspNet.Authentication.Google": "1.0.0-beta7",
"Microsoft.AspNet.Authentication.MicrosoftAccount": "1.0.0-beta7",
"Microsoft.AspNet.Authentication.Twitter": "1.0.0-beta7",
"Microsoft.AspNet.Diagnostics": "1.0.0-beta7",
"Microsoft.AspNet.Diagnostics.Entity": "7.0.0-beta7",
"Microsoft.AspNet.Identity.EntityFramework": "3.0.0-beta7",
"Microsoft.AspNet.Mvc": "6.0.0-beta7",
"Microsoft.AspNet.Mvc.TagHelpers": "6.0.0-beta7",
"Microsoft.AspNet.Server.IIS": "1.0.0-beta7",
"Microsoft.AspNet.Server.WebListener": "1.0.0-beta7",
"Microsoft.AspNet.StaticFiles": "1.0.0-beta7",
"Microsoft.AspNet.Tooling.Razor": "1.0.0-beta7",
"Microsoft.Framework.Configuration.Abstractions": "1.0.0-beta7",
"Microsoft.Framework.Configuration.Json": "1.0.0-beta7",
"Microsoft.Framework.Configuration.UserSecrets": "1.0.0-beta7",
"Microsoft.Framework.Logging": "1.0.0-beta7",
"Microsoft.Framework.Logging.Console": "1.0.0-beta7",
"Microsoft.Framework.Logging.Debug" : "1.0.0-beta7",
"Microsoft.VisualStudio.Web.BrowserLink.Loader": "14.0.0-beta7"
},
"commands": {
"web": "Microsoft.AspNet.Hosting --config hosting.ini",
"ef": "EntityFramework.Commands"
},
"frameworks": {
"dnx451": { },
"dnxcore50": { }
},
"exclude": [
"wwwroot",
"node_modules",
"bower_components"
],
"publishExclude": [
"node_modules",
"bower_components",
"**.xproj",
"**.user",
"**.vspscc"
],
"scripts": {
"prepublish": [ "npm install", "bower install", "gulp clean", "gulp min" ]
}
}
Facendo una ricerca online sembrava che per realizzare ciò che volevo avevo bisogno di eseguire il seguente comando:
dnx ef dbcontext scaffold "ConnectionString" EntityFramework.SqlServer
Quale non potrei fare perché ho avuto un problema che è stato risolto come spiegato qui: Utilizzo del database esistente con ASP.NET 5 e EF7 (beta 7)
Ora posso finalmente eseguire il comando "dnx", ma quando provo a eseguirlo con il mio connectiontring, che assomiglia a questo:
dnx ef dbcontext scaffold "Data Source=192.168.XX.XXX\devsql;Initial
Catalog=Development;Integrated Security=False;User ID=system;Password=XXX;"
EntityFramework.SqlServer
mi dà i seguenti errori:
[ERROR] dnx : System.InvalidOperationException: Failed to resolve the
following dependencies for target framework 'DNXCore,Version=v5.0':
[ERROR] En lÃnea: 1 Carácter: 1 [ERROR] + dnx ef dbcontext scaffold
"Data Source=192.168.XX.XXX\devsql;Initial Catalog=Dev ... [ERROR] +
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
[ERROR] + CategoryInfo : NotSpecified:
(System.InvalidO...,Version=v5.0'::String) [], RemoteException [ERROR]
+ FullyQualifiedErrorId : NativeCommandError [ERROR] [ERROR] EntityFramework.Commands 7.0.0-beta7 [ERROR]
EntityFramework.SqlServer 7.0.0-beta7 [ERROR]
Microsoft.AspNet.Authentication.Cookies 1.0.0 [ERROR] -beta7 [ERROR]
Microsoft.AspNet.Authentication.Facebook 1.0.0-beta7 [ERROR]
Microsoft.AspNet.Authentication.Google 1.0.0-beta7 [ERROR]
Microsoft.AspNet.Authentication.MicrosoftAccount 1.0.0-beta7 [ERROR]
Microsoft.AspNet.Authentication.Twitter 1.0.0-beta7 [ERROR]
Microsoft.AspNet.Diagnostics 1.0.0-beta7 [ERROR]
Microsoft.AspNet.Diagnostics.Entity 7.0.0-beta7 [ERROR]
Microsoft.AspNet.Identity.EntityFramework 3.0.0-beta7 [ERROR]
Microsoft.AspNet.Mvc 6.0.0-beta7 [ERROR]
Microsoft.AspNet.Mvc.TagHelpers 6.0.0-beta7 [ERROR]
Microsoft.AspNet.Server.IIS 1.0.0-beta7 [ERROR]
Microsoft.AspNet.Server.WebListener 1.0.0-beta7 [ERROR]
Microsoft.AspNet.StaticFiles 1.0.0-beta7 [ERROR]
Microsoft.AspNet.Tooling.Razor 1.0.0-beta7 [ERROR]
Microsoft.Framework.Configuration.Abstractions 1.0.0-beta7 [ERROR]
Microsoft.Framework.Configuration.Json 1.0.0-beta7 [ERROR]
Microsoft.Framework.Configuration.UserSecrets 1.0.0-beta7 [ERROR]
Microsoft.Framework.Logging 1.0.0-beta7 [ERROR]
Microsoft.Framework.Logging.Console 1.0.0-beta7 [ERROR]
Microsoft.Framework.Logging.Debug 1.0.0-beta7 [ERROR]
Microsoft.VisualStudio.Web.BrowserLink.Loader 14.0.0-beta7 [ERROR]
[ERROR]
C:\XXX\XXX\src\XXX\project.lock.json(1,0):
error: The expected lock file doesn't exist. Please run "dnu restore"
to generate a new lock file. [ERROR] Current runtime target framework:
'DNXCore,Version=v5.0 (dnxcore50)' [ERROR] Version:
1.0.0-beta7-15532 [ERROR] Type: CoreCLR [ERROR] Architecture: x64 [ERROR] OS Name: Windows [ERROR] OS Version:
6.1 [ERROR] [ERROR] at Microsoft.Dnx.Runtime.DefaultHost.GetEntryPoint(String
applicationName) [ERROR] at
Microsoft.Dnx.ApplicationHost.Program.ExecuteMain(DefaultHost host,
String applicationName, String[] args) [ERROR] at
Microsoft.Dnx.ApplicationHost.Program.Main(String[] args) [ERROR] ---
End of stack trace from previous location where exception was thrown
--- [ERROR] at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() [ERROR]
at Microsoft.Dnx.Runtime.Common.EntryPointExecutor.Execute(Assembly
assembly, String[] args, IServiceProvider serviceProvider) [ERROR]
at Microsoft.Dnx.Host.Bootstrapper.RunAsync(List`1 args,
IRuntimeEnvironment env, FrameworkName targetFramework) [ERROR] at
Microsoft.Dnx.Host.RuntimeBootstrapper.ExecuteAsync(String[] args,
FrameworkName targetFramework) [ERROR] at
Microsoft.Dnx.Host.RuntimeBootstrapper.Execute(String[] args,
FrameworkName targetFramework) [ERROR]
dato che
[ERROR]
C:\XXX\XXX\src\XXX\project.lock.json(1,0):
error: The expected lock file doesn't exist. Please run "dnu restore"
to generate a new lock file.
Ho provato a correre
PS C:\XXX\XXX> dnu restore
Microsoft .NET Development Utility CoreCLR-x64-1.0.0-beta7-15532
CACHE https://api.nuget.org/v3/index.json Restoring packages for
C:\XXX\XXX\src\XXX\project.json CACHE
https://api.nuget.org/v3-flatcontainer/system.threading.threadpool/index.json
GET
https://api.nuget.org/v3-flatcontainer/system.net.sockets/index.json
OK
https://api.nuget.org/v3-flatcontainer/system.net.sockets/index.json
1117ms Writing lock file
C:\XXX\XXX\src\XXX\project.lock.json Restore
complete, 2071ms elapsed
NuGet Config files used:
C:\Users\XXX\AppData\Roaming\NuGet\NuGet.Config
C:\XXX\XXX\NuGet.Config
Feeds used:
https://api.nuget.org/v3-flatcontainer/
Il che ricrea il project.lock.json con successo, a quanto pare (timestamp riflette anche questo). Tuttavia, quando provo di nuovo a eseguire lo script scaffold, continua a mostrare lo stesso errore mostrato sopra, inclusa la parte "il file di blocco previsto non esiste".
Qualche idea di cosa sta andando storto?
Ho affrontato lo stesso problema e l'ho risolto con: - Fai clic destro su "Riferimenti" - Seleziona "Ripristina pacchetti"
Oppure Ctrl + Shilf + R
Creerà / aggiornerà il file "project.lock.json", che include un elenco completo di tutti i pacchetti NuGet utilizzati dall'app. Secondo me, non dovresti metterlo nel controllo del codice sorgente
Prova questo:
Chiudi Visual Studio completamente .
Aprire una finestra del prompt dei comandi di Visual Studio .
cd C:\XXX\XXX\src\XXX\
dnu restore
dnx ef dbcontext scaffold "ConnectionString" EntityFramework.SqlServer