Best Of
Re: How would I map Spatial Data for EF Core 3.x?
Adding NetTopologySuite.Core does not fix the problem in LinqPad.
I believe this is because LinqPad is not referencing the required spatial geography packages NetTopologySuite.Core package and Microsoft.EntityFrameworkCore.SqlServer.NetTopologySuite package when creating the custom DBContext for the (Entity Framework Core (multi-provider) option.
I was able to confirm this by clicking the “Show Assembly Resolution Log”, I didn't see the required package for SQL Server, resulting in EF Core skipping all geography columns.
According to Microsoft, there’s a separate Spatial Geography package required for each EF Core Provider:
An additional package NetTopologySuite.Core is also required regardless of the EF Core Provider.
In a Visual Studio project, I was able to successfully scaffold the geography type for SQL Server when I included the Microsoft.EntityFrameworkCore.SqlServer.NetTopologySuite
and NetTopologySuite.Core packages in the project.
It would be great if LinqPad would automatically include the Spatial Geography packages listed above when using the (Entity Framework Core (multi-provider) option, as it would save us the time from creating a separate project and building a DLL to use spatial data. The Entity Framework Core (multi-provider) option is much more convenient!
Thanks in advance!
I believe this is because LinqPad is not referencing the required spatial geography packages NetTopologySuite.Core package and Microsoft.EntityFrameworkCore.SqlServer.NetTopologySuite package when creating the custom DBContext for the (Entity Framework Core (multi-provider) option.
I was able to confirm this by clicking the “Show Assembly Resolution Log”, I didn't see the required package for SQL Server, resulting in EF Core skipping all geography columns.
According to Microsoft, there’s a separate Spatial Geography package required for each EF Core Provider:
| EF Core Provider | Required Spatial NuGet Package |
|---|---|
| Microsoft.EntityFrameworkCore.SqlServer | Microsoft.EntityFrameworkCore.SqlServer.NetTopologySuite |
| Microsoft.EntityFrameworkCore.Sqlite | Microsoft.EntityFrameworkCore.Sqlite.NetTopologySuite |
| Microsoft.EntityFrameworkCore.InMemory | NetTopologySuite |
| Npgsql.EntityFrameworkCore.PostgreSQL | Npgsql.EntityFrameworkCore.PostgreSQL.NetTopologySuite |
An additional package NetTopologySuite.Core is also required regardless of the EF Core Provider.
In a Visual Studio project, I was able to successfully scaffold the geography type for SQL Server when I included the Microsoft.EntityFrameworkCore.SqlServer.NetTopologySuite
and NetTopologySuite.Core packages in the project.
It would be great if LinqPad would automatically include the Spatial Geography packages listed above when using the (Entity Framework Core (multi-provider) option, as it would save us the time from creating a separate project and building a DLL to use spatial data. The Entity Framework Core (multi-provider) option is much more convenient!
Thanks in advance!
KMW
1 ·
Re: LINQPad 6 for .NET Core 3 - preview now available!
My LINQPad 6 beta just updated itself to v6.0.11 and now every time I run a query I get a message that says, "The connection for this query relies on...EF7Driver". If I hit, "Yes", a window comes up but there are no drivers available to download. If I hit, "No", the query executes just fine.
Thanks for the help. Also, absolutely fantastic product!
-Scott
Thanks for the help. Also, absolutely fantastic product!
-Scott
SSSikora
1 ·
Close Button for Tabs
Hi Joseph Albahari!
Please, can you add a close button to the opened tabs it will be really helpful.
Thanks
Please, can you add a close button to the opened tabs it will be really helpful.
Thanks
billarcc
1 ·
Re: Can't set breakpoint in UI click handler
The problem is that your program completes the moment
You need to signal to LINQPad that your query is still running so it could continue to keep tabs on your program. You could do this by preventing
Main() returns. The action you're attempting to step through is run well after the debugger is detached.You need to signal to LINQPad that your query is still running so it could continue to keep tabs on your program. You could do this by preventing
Main() from returning or call Util.KeepRunning() to obtain an object that you can keep around which you can dispose when you're actually finished (or not dispose at all).
void Main()
{
Util.KeepRunning();
var runBtn = new Button("Run", Run).Dump("Click");
}
JeffMercado
2 ·
Re: Global flag for unsafe?
I'm not sure that we need an option - can you think of any reason why unsafe shouldn't just be the default?
JoeAlbahari
1 ·
Linqpad 6 Oracle via EF Core
Hi all,
I'm trying to get my new Linqpad 6 connected to an oracle database using the new native EF core behaviour, and having some issues.
I *can* connect as SYSDBA and see all the SYS tables. That means it's not plumbing specifically - the port, service, and so on all work and allow me to correctly access the DB. I can also log in and connect using my application credentials.
However if i try to access any tables in my application schema (in either case) I get nothing. The table browser treeview says ...loading... for a few seconds then just ends. I presume it either cannot find any tables, or there is an unsupported or broken table/something in my schema.
I'm wondering how i can best debug this process? how do i see logs, errors, issues etc in the "....loading..." phase of enumerating all the tables in my database?
my scenario: Oracle running in local docker container hence connecting on localhost:15XX. service name of foo.mycompany.com sid of foo. user data schema of FOO_APPDATA
Cheers!
-d
I'm trying to get my new Linqpad 6 connected to an oracle database using the new native EF core behaviour, and having some issues.
I *can* connect as SYSDBA and see all the SYS tables. That means it's not plumbing specifically - the port, service, and so on all work and allow me to correctly access the DB. I can also log in and connect using my application credentials.
However if i try to access any tables in my application schema (in either case) I get nothing. The table browser treeview says ...loading... for a few seconds then just ends. I presume it either cannot find any tables, or there is an unsupported or broken table/something in my schema.
I'm wondering how i can best debug this process? how do i see logs, errors, issues etc in the "....loading..." phase of enumerating all the tables in my database?
my scenario: Oracle running in local docker container hence connecting on localhost:15XX. service name of foo.mycompany.com sid of foo. user data schema of FOO_APPDATA
Cheers!
-d
dmeeze
2 ·
Re: LinqPad with custom DbContext in custom DLL - CS0120 error
Hi,
I have a similar problem with the error "CS0120 An object reference is required for the non-static field, method, or property FntDbContext.System"
Maybe the culprit is that a table in my MySql has the name `system` which when scaffolded in EF Core is generated as the entity `System`.
Can you check if you have a table `system` in your database?
I have no problems with accessing and running in an ASP.NET Core MVC solution though,
I've tried for ease of development to use LinqPad, but after successfully creating the Connection with the EF Core driver, I cannot make a single query due to the aforementioned error.
I have a similar problem with the error "CS0120 An object reference is required for the non-static field, method, or property FntDbContext.System"
Maybe the culprit is that a table in my MySql has the name `system` which when scaffolded in EF Core is generated as the entity `System`.
Can you check if you have a table `system` in your database?
I have no problems with accessing and running in an ASP.NET Core MVC solution though,
I've tried for ease of development to use LinqPad, but after successfully creating the Connection with the EF Core driver, I cannot make a single query due to the aforementioned error.
gtaranti
1 ·
Re: LinqPad with custom DbContext in custom DLL - CS0120 error
Just a follow-up.
After changing the database table name from `system` to `machinery` everything is fine.
This, for me, is proof that LinqPad (version 5.36.03) has this odd behaviour and "choke" if the table name is system
After changing the database table name from `system` to `machinery` everything is fine.
This, for me, is proof that LinqPad (version 5.36.03) has this odd behaviour and "choke" if the table name is system
gtaranti
1 ·
Re: System.Data.SqlClient removed as a default namespace in LINQPad 6?
I think this is reasonable since .NET Core 3.0 removed SqlClient by default and introduced Microsoft.Data.SqlClient, which is also a breaking change.
sdflysha
1 ·
CS0570 'AvailableItems.GetListAsync(string)' is not supported by the language
I am getting the message above when using a .NET Standard class recently compiled with Visual Studio 2017 15.8.9 and with the Advanced Build Settings, Language version set to C# latest minor version.
The method definition is: public async Task> GetListAsync(String filter)
I tried enabling the Use experimental Roslyn assemblies which says Current Version 2.9.0.0 (up to date) but since that did not resolve the issue I am guessing that is not what I needed to enable. Is there a way to get support for my return of a ValueTuple? This works in Visual Studio and with my unit tests that call it for testing purposes.
Thank you in advance.
The method definition is: public async Task> GetListAsync(String filter)
I tried enabling the Use experimental Roslyn assemblies which says Current Version 2.9.0.0 (up to date) but since that did not resolve the issue I am guessing that is not what I needed to enable. Is there a way to get support for my return of a ValueTuple? This works in Visual Studio and with my unit tests that call it for testing purposes.
Thank you in advance.
wjvii
1 ·