Error when trying to connect to SQL server #215
Comments
|
What operating system are you running? Also is it x64 or ARM? |
|
EndeavourOS (Arch Linux based) x64 |
|
EDIT: After update to 0.7.2, the error changed to:
(Copied from terminal execution of AppImage) Same environment as before |
|
@faahiero thanks for the update. I wasn't able to replicate this on my system (Arch Linux) or on other Windows and macOS machines, but I was able to replicate on one specific macOS VM. But even there, I can make the error show up only if I try to expand the connection in the tree to get the tables, but if I run a script using that connection it works just fine. Does running a script against the connection work for you? |
|
@tareqimbasher Yes, I tested it now that you mentioned, and the connection works fine when I run scripts against the database, whether pure SQL Queries or LINQ/Lambda Expressions. But the table structure tree continues to show an error. |
|
Thanks for confirming. I'll check out the issue with the tree view. Can you please post |
|
Similar issue on my PC, 😢 with NetPad v0.7.2 running on Windows 11 Pro (23H2). In the (New/Edit) Data Connection dialog window, I can connect to But expanding the structure tree doesn't work, nor does running a SQL statement in a Script tab. Both actions result in the same error: No scaffolded files found in output dir. Below I have included the output of Exception stack traceSystem.InvalidOperationException: No scaffolded files found in output dir.
at NetPad.Apps.Data.EntityFrameworkCore.Scaffolding.EntityFrameworkDatabaseScaffolder.GetScaffoldedModelAsync() in /home/tips/Source/TIPS/NetPad/src/Apps/NetPad.Apps.Common/Data/EntityFrameworkCore/Scaffolding/EntityFrameworkDatabaseScaffolder.cs:line 219
at NetPad.Apps.Data.EntityFrameworkCore.Scaffolding.EntityFrameworkDatabaseScaffolder.ScaffoldAsync() in /home/tips/Source/TIPS/NetPad/src/Apps/NetPad.Apps.Common/Data/EntityFrameworkCore/Scaffolding/EntityFrameworkDatabaseScaffolder.cs:line 59
at NetPad.Apps.Data.EntityFrameworkCore.Scaffolding.EntityFrameworkDatabaseScaffolder.ScaffoldAsync() in /home/tips/Source/TIPS/NetPad/src/Apps/NetPad.Apps.Common/Data/EntityFrameworkCore/Scaffolding/EntityFrameworkDatabaseScaffolder.cs:line 67
at NetPad.Apps.Data.EntityFrameworkCore.EntityFrameworkResourcesGenerator.GenerateSourceCodeAsync(DataConnection dataConnection, DotNetFrameworkVersion targetFrameworkVersion) in /home/tips/Source/TIPS/NetPad/src/Apps/NetPad.Apps.Common/Data/EntityFrameworkCore/EntityFrameworkResourcesGenerator.cs:line 39
at NetPad.Apps.Data.FileSystemDataConnectionResourcesCache.<>c__DisplayClass13_0.<<GetSourceGeneratedCodeAsync>b__0>d.MoveNext() in /home/tips/Source/TIPS/NetPad/src/Apps/NetPad.Apps.Common/Data/FileSystemDataConnectionResourcesCache.cs:line 103
--- End of stack trace from previous location ---
at NetPad.Apps.Data.FileSystemDataConnectionResourcesCache.GetSourceGeneratedCodeAsync(DataConnection dataConnection, DotNetFrameworkVersion targetFrameworkVersion) in /home/tips/Source/TIPS/NetPad/src/Apps/NetPad.Apps.Common/Data/FileSystemDataConnectionResourcesCache.cs:line 129
at NetPad.ExecutionModel.External.ExternalScriptRunner.GetDataConnectionResourcesAsync(DataConnection dataConnection) in /home/tips/Source/TIPS/NetPad/src/Core/NetPad.Runtime/ExecutionModel/External/ExternalScriptRunner.Setup.cs:line 131
at NetPad.ExecutionModel.External.ExternalScriptRunner.GetRunDependencies(RunOptions runOptions) in /home/tips/Source/TIPS/NetPad/src/Core/NetPad.Runtime/ExecutionModel/External/ExternalScriptRunner.Setup.cs:line 33
at NetPad.ExecutionModel.External.ExternalScriptRunner.RunScriptAsync(RunOptions runOptions) in /home/tips/Source/TIPS/NetPad/src/Core/NetPad.Runtime/ExecutionModel/External/ExternalScriptRunner.cs:line 105( Copied from NetPad output pane, after trying to run a simple SELECT SQL query. ) Output of
|
|
@RichardNobel thanks for the report. A .NET 6 Runtime or SDK is needed for the treeview to work correctly but I'm not sure yet if it being missing on your machine is what's causing this particular issue. Do you mind installing .NET 6 Runtime or SDK, restarting NetPad and see if you still get the same error? And you can get to that window you were looking for by clicking the computer icon on the bottom right corner of the main window. |
|
I'm experiencing a similar issue when trying to run a query against a SQL database. Unlike the original post, the tree view fully loads in my case, after duplicating the connection. Here's the error I'm encountering: Environment details:
Note: Normal queries without a connection work fine. For example: This outputs |
I have installed the .NET 6 SDK. Details
.NET SDKs installed:
6.0.423 [C:\Program Files\dotnet\sdk]
8.0.204 [C:\Program Files\dotnet\sdk]
.NET runtimes installed:
Microsoft.AspNetCore.App 6.0.31 [C:\Program Files\dotnet\shared\Microsoft.AspNetCore.App]
Microsoft.AspNetCore.App 8.0.4 [C:\Program Files\dotnet\shared\Microsoft.AspNetCore.App]
Microsoft.NETCore.App 6.0.31 [C:\Program Files\dotnet\shared\Microsoft.NETCore.App]
Microsoft.NETCore.App 8.0.4 [C:\Program Files\dotnet\shared\Microsoft.NETCore.App]
Microsoft.WindowsDesktop.App 6.0.31 [C:\Program Files\dotnet\shared\Microsoft.WindowsDesktop.App]
Microsoft.WindowsDesktop.App 8.0.4 [C:\Program Files\dotnet\shared\Microsoft.WindowsDesktop.App]And, after restarting NetPad, now I can select either .NET 8 or .NET 6 on a Script tab.
Thanks. Seeing this window again 🤔 made me think: Could the version (
|
To answer my own question: downgrading dotnet-ef tools (uninstalling v8, then installing v6), doesn't appear to fix the Scaffolding. 🫤
|
|
@RichardNobel thank you for testing that and reporting back, I'll take a look at this and get a fix out soon! |
Sure, here: |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
After configure the user, pass, select database and check connection, when try to access database structure in Connections Panel, it shows me the following error:
.NET SDK and Runtime installed
The text was updated successfully, but these errors were encountered: