Best Of

Re: Entity Framework DbCommandInterceptor vs. SQL panel (LINQPad 5)

The behavior makes sense, because LINQPad installs its DbCommandInterceptor first.

You can tell LINQPad not to write SQL translations by doing this in your setup code:

ExecutionEngine.SqlTranslationsEnabled = false;

Then in your ReaderExecuting method:

Util.SqlOutputWriter.Write (command.CommandText);

JoeAlbahari

1 ·

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:

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

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

billarcc

1 ·

Re: Can't set breakpoint in UI click handler

The problem is that your program completes the moment 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

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.

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

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 ·