linq2db / linq2db.linqpad Goto Github PK

View Code? Open in Web Editor NEW

73.0 73.0 22.0 382.76 MB

linq2db.LINQPad is a driver for LINQPad.

License: MIT License

C# 97.50% Batchfile 0.50% PowerShell 2.00%

linq linq2db linqpad

linq2db.linqpad's People

Contributors

Stargazers

Watchers

linq2db.linqpad's Issues

How to specify the sql server version?

I need to connect to SQL Server 2000. thanks!

MysqlDriver retrieved the wrong count row

actually, the truth row is 13 but LinqPad always retrieved 10-row data. in the end, I try to delete one row, It is 12 rows, but that retrieved 10 rows again.

TheTestMysqlDataDemo.zip

MysqlDataBase info:
Server: MySQL (127.0.0.1 via TCP/IP)
Server type: MySQL
Server version: 5.7.30 - MySQL Community Server (GPL)
Protocol version: 10
User: root@localhost
Server charset: UTF-8 Unicode (utf8)

window 10 64bit Pro 21H1

Upgrade System.DirectoryServices.Protocols version

I setup linq2db.LINQPad 3.6.0, LINQPad will show a alert.

Warning: LINQPad has identified the following vulnerabilties in NuGet package System.DirectoryServices.Protocols 5.0.0:

Level 1 (Moderate): https://github.com/advisories/GHSA-9cxh-gqpx-qc5m
Try updating NuGet packages to latest. You can suppress this warning in Edit | Preferences > Advanced > Execution.

Unhandled error in method 'PreprocessObjectToWrite' for LINQPad8

LP8 - When the query is set to a linqpad connection, dumping any sequence of items will encounter the following error:

Unhandled error in method 'PreprocessObjectToWrite':
  The type initializer for 'LinqToDB.LlNQPad.ValueFormatter' threw an exception.
    at LinqToDB.LlNQPad.ValueFormatter.Format(Object value)
    at LinqToDB.LlNQPad.LinqToDBDriver.PreprocessObjectToWrite(Object& objectToWrite, ObjectGraphlnfo info)

LINQPad error appears with both versions 5.0.0 and 5.1.0 (for LINQPad versions 8.0.12 and 8.0.13).

Downloading driver from LinqPad links to a parked domain

So, tried downloading an updated Linq2db driver from the LinqPad dialog box, and it wasn't working. Turns out it links to:
http://tkachev.com/linq2db/linq2db.LINQPad.lpx

Which now looks like a parked domain.

Vulnerability Issue

Hi there I am using this driver and I am seeing these errors. Can it be updated to address the vulnerabilities?

Disable procedures and functions load by default

Right now it is enabled by default, which could be dangerous, as it leads to procedure execution in schema-only mode.
Usually it is safe, but for some databases combined with some specific procedure code it could lead to real execution (full or partial), so we should force user to accept risk explicitly.

LINQPad crash when connecting to Access (2003 - .mdb) database with linked tables

This seems to be an issue with linked tables, but I'm not actually getting an error just a crash.

I have one .mdb file that I split in two - one for the data and one for the rest. Linking to the non-data table causes LINQPad to crash outright. They both have security (the old workgroup kind, with a Security.mdw file), but I tried it without security and it still happened.

Linking to just the data table works fine, and makes more sense to do anyway, but just wanted to give you a heads up about the crash.

When I hit debug instead of close, I do get this in VS, if that helps:
Unhandled exception at 0x59B8E861 (msjetoledb40.dll) in LINQPad.exe: RangeChecks instrumentation code detected an out of range array access.

Using this driver results in a warning (System.DirectoryServices.Protocols 5.0.0 vulnerability)

When using this driver in LINQPad 7.3.9, a warning is emitted at the beginning of the run:

Warning: LINQPad has identified the following vulnerabilties in NuGet package System.DirectoryServices.Protocols 5.0.0:

Level 1 (Moderate): GHSA-9cxh-gqpx-qc5m
Try updating NuGet packages to latest. You can suppress this warning in Edit | Preferences > Advanced > Execution.

The dependency tree seems to be:

linq2db 3.6.0
- Oracle.ManagedDataAccess.Core 3.21.4
  - System.DirectoryServices.Protocols 5.0.0

This should be resolved by bumping the linq2db version used to either 3.7.0 or 4.0.0.

linq2db 3.7.0
- Oracle.ManagedDataAccess.Core 3.21.50
  - System.DirectoryServices.Protocols 5.0.1
linq2db 4.0.0
- Oracle.ManagedDataAccess.Core 2.19.140
  - no System.DirectoryServices.Protocols dependency

IBM.Data.DB2.iSeries DLL

It would be nice if this could support the DB2 for iSeries dll available from
https://www.nuget.org/packages/IBM.Data.DB2.iSeries/
in your redist folder
https://github.com/linq2db/linq2db.LINQPad/tree/master/Redist/IBM

Properties from custom assembly are in random order

When using a context from a custom assembly, the properties are displayed in a random order. I will prepare a PR to sort them.

Can't close connection

Using the default LINQ to SQL driver for Sql Server, the Connection object in a LinqPad script starts out in a closed state and can be opened and closed as needed. But using the Linq2db driver (for a Postgres database), Connection starts out in an open state -- and it appears that calling Close() has no effect.

Connection.State.Dump();   // Open
Connection.Close();
Connection.State.Dump();   // Open

Is there a way to either get the connection to start closed, or to close it by hand?

SAP Sybase ASE broken

I am trying to connect to a Sybase database in Linqpad. After downloading the Linq to DB Connection driver, I choose SAP Sybase ASE as the data provider. I put in the connection string items, then try to connect. I am getting an error that says:
"Unable to find the requested .Net Framework Data Provider. It may not be installed"

Is anyone else able to connect to a sybase database using this driver? What can I do?

No control over table name capitalization.

Tables and views in my databases often have names with specified capitalization, and previously the L2DB driver has left them intact. The new v5.0.0 driver however forces PascalCase on table and view names during refresh, with no apparent setting to disable this.

Example: View VDRMSite is generated as VdrmSite.

When testing code snippets or writing quick scripts the change in case for many of my table names wastes a ton of time as I have to search for the table in the tree view to find out what whacky name L2DB gave it.

Can we please get an option to use unmodified table names for class and property names where possible?

Incompatibility with a particular Microsoft Access Database.

I encountered the error message shown in the screenshot below when trying to add a connection to a particular Microsoft Access Database. The database file is attached in the Zip file below.

At the "LINQ to DB Connection" dialog box, clicking on the Test button results in a successful test.

The accdb file opens fine in Microsoft Access 2013. LINQ2DB doesn't seem to have a problem in mapping out a database with no primary keys defined because I had a similarly structured Access Database that works great with LINQ2DB.

Note: I did not design the Access database. It's taken from a third-party software. So, I have no control over its design.

The LINQ2DB LINQPad driver that I'm using is of version 1.0.52 on LINQPad v5.22.02 .

Access Database.zip

Update target framework to 3.1

Latest version of LINQPad dropped today and all of my linq2db connections started blowing up. This might have been related to VS2019 installing .NET Core 3.0 target pack when I opened an older project.

Long story short, since linq2db.LINQPad targets .NET Core 3.0 LINQPad runs it under that framework. That works all the way up until the driver tries to load the linq2db assembly which requires .NET Core 3.1.

Can you please bump the target framework to netcoreapp3.1 and push a new version out to nuget? I don't want to have to go through purging .NET Core 3.0 every time I open an old project 😄

(I mean, I could build a custom version of the driver, but... yeah, nah)

Adding MySQL broken

LP6/7, x86/x64.

Trying to add a MySql server.

Pasted a correct connection string, pressed Test, got Successful!
Pressed OK, the window got frozen, pressed the window close cross, got the standard Not Responding dialog, pressed Try to restore program, got

Pressed Yes, got a message box with this:

---------------------------
Schema Build Error
---------------------------
System.MissingMethodException: Method not found: 'System.Collections.Immutable.ImmutableArray`1<Byte> System.Reflection.Metadata.MetadataReader.GetBlobContent(System.Reflection.Metadata.BlobHandle)'.

   at Microsoft.CodeAnalysis.MetadataReaderExtensions.CreateAssemblyIdentityOrThrow(MetadataReader reader, Version version, AssemblyFlags flags, BlobHandle publicKey, StringHandle name, StringHandle culture, Boolean isReference)

   at Microsoft.CodeAnalysis.MetadataReaderExtensions.ReadAssemblyIdentityOrThrow(MetadataReader reader) in /_/src/Compilers/Core/Portable/MetadataReader/MetadataReaderExtensions.cs:line 52

   at Microsoft.CodeAnalysis.PEAssembly..ctor(AssemblyMetadata owner, ImmutableArray`1 modules) in /_/src/Compilers/Core/Portable/MetadataReader/PEAssembly.cs:line 59

   at Microsoft.CodeAnalysis.AssemblyMetadata.GetOrCreateData() in /_/src/Compilers/Core/Portable/MetadataReference/AssemblyMetadata.cs:line 342

   at Microsoft.CodeAnalysis.AssemblyMetadata.GetModules() in /_/src/Compilers/Core/Portable/MetadataReference/AssemblyMetadata.cs:line 283

   at Microsoft.CodeAnalysis.AssemblyMetadata.IsValidAssembly() in /_/src/Compilers/Core/Portable/MetadataReference/AssemblyMetadata.cs:line 410

   at Microsoft.CodeAnalysis.CommonReferenceManager`2.GetMetadata(PortableExecutableReference peReference, CommonMessageProvider messageProvider, Location location, DiagnosticBag diagnostics) in /_/src/Compilers/Core/Portable/ReferenceManager/CommonReferenceManager.Resolution.cs:line 496

   at Microsoft.CodeAnalysis.CommonReferenceManager`2.ResolveMetadataReferences(TCompilation compilation, Dictionary`2 assemblyReferencesBySimpleName, ImmutableArray`1& references, IDictionary`2& boundReferenceDirectiveMap, ImmutableArray`1& boundReferenceDirectives, ImmutableArray`1& assemblies, ImmutableArray`1& modules, DiagnosticBag diagnostics) in /_/src/Compilers/Core/Portable/ReferenceManager/CommonReferenceManager.Resolution.cs:line 321

   at Microsoft.CodeAnalysis.CSharp.CSharpCompilation.ReferenceManager.CreateAndSetSourceAssemblyFullBind(CSharpCompilation compilation) in /_/src/Compilers/CSharp/Portable/Symbols/ReferenceManager.cs:line 357

   at Microsoft.CodeAnalysis.CSharp.CSharpCompilation.ReferenceManager.CreateSourceAssemblyForCompilation(CSharpCompilation compilation) in /_/src/Compilers/CSharp/Portable/Symbols/ReferenceManager.cs:line 184

   at Microsoft.CodeAnalysis.CSharp.CSharpCompilation.GetBoundReferenceManager() in /_/src/Compilers/CSharp/Portable/Compilation/CSharpCompilation.cs:line 1033

   at Microsoft.CodeAnalysis.CSharp.CSharpCompilation.get_SourceAssembly() in /_/src/Compilers/CSharp/Portable/Compilation/CSharpCompilation.cs:line 1257

   at Microsoft.CodeAnalysis.CSharp.CSharpCompilation.get_Assembly() in /_/src/Compilers/CSharp/Portable/Compilation/CSharpCompilation.cs:line 1270

   at Microsoft.CodeAnalysis.CSharp.CSharpCompilation.GetRuntimeMetadataVersion(EmitOptions emitOptions) in /_/src/Compilers/CSharp/Portable/Compilation/CSharpCompilation.cs:line 3394

   at Microsoft.CodeAnalysis.CSharp.CSharpCompilation.GetRuntimeMetadataVersion(EmitOptions emitOptions, DiagnosticBag diagnostics) in /_/src/Compilers/CSharp/Portable/Compilation/CSharpCompilation.cs:line 3376

   at Microsoft.CodeAnalysis.CSharp.CSharpCompilation.CreateModuleBuilder(EmitOptions emitOptions, IMethodSymbol debugEntryPoint, Stream sourceLinkStream, IEnumerable`1 embeddedTexts, IEnumerable`1 manifestResources, CompilationTestData testData, DiagnosticBag diagnostics, CancellationToken cancellationToken) in /_/src/Compilers/CSharp/Portable/Compilation/CSharpCompilation.cs:line 3121

   at Microsoft.CodeAnalysis.Compilation.CheckOptionsAndCreateModuleBuilder(DiagnosticBag diagnostics, IEnumerable`1 manifestResources, EmitOptions options, IMethodSymbol debugEntryPoint, Stream sourceLinkStream, IEnumerable`1 embeddedTexts, CompilationTestData testData, CancellationToken cancellationToken) in /_/src/Compilers/Core/Portable/Compilation/Compilation.cs:line 3062

   at Microsoft.CodeAnalysis.Compilation.Emit(Stream peStream, Stream metadataPEStream, Stream pdbStream, Stream xmlDocumentationStream, Stream win32Resources, IEnumerable`1 manifestResources, EmitOptions options, IMethodSymbol debugEntryPoint, Stream sourceLinkStream, IEnumerable`1 embeddedTexts, RebuildData rebuildData, CompilationTestData testData, CancellationToken cancellationToken) in /_/src/Compilers/Core/Portable/Compilation/Compilation.cs:line 2821

   at Microsoft.CodeAnalysis.Compilation.Emit(Stream peStream, Stream pdbStream, Stream xmlDocumentationStream, Stream win32Resources, IEnumerable`1 manifestResources, EmitOptions options, IMethodSymbol debugEntryPoint, Stream sourceLinkStream, IEnumerable`1 embeddedTexts, Stream metadataPEStream, RebuildData rebuildData, CancellationToken cancellationToken) in /_/src/Compilers/Core/Portable/Compilation/Compilation.cs:line 2778

   at LinqToDB.LINQPad.LinqToDBDriver.GetSchemaAndBuildAssembly(IConnectionInfo cxInfo, AssemblyName assemblyToBuild, String& nameSpace, String& typeName)
   at Microsoft.CodeAnalysis.MetadataReaderExtensions.CreateAssemblyIdentityOrThrow(MetadataReader reader, Version version, AssemblyFlags flags, BlobHandle publicKey, StringHandle name, StringHandle culture, Boolean isReference)

   at Microsoft.CodeAnalysis.MetadataReaderExtensions.ReadAssemblyIdentityOrThrow(MetadataReader reader) in /_/src/Compilers/Core/Portable/MetadataReader/MetadataReaderExtensions.cs:line 52

   at Microsoft.CodeAnalysis.PEAssembly..ctor(AssemblyMetadata owner, ImmutableArray`1 modules) in /_/src/Compilers/Core/Portable/MetadataReader/PEAssembly.cs:line 59

   at Microsoft.CodeAnalysis.AssemblyMetadata.GetOrCreateData() in /_/src/Compilers/Core/Portable/MetadataReference/AssemblyMetadata.cs:line 342

   at Microsoft.CodeAnalysis.AssemblyMetadata.GetModules() in /_/src/Compilers/Core/Portable/MetadataReference/AssemblyMetadata.cs:line 283

   at Microsoft.CodeAnalysis.AssemblyMetadata.IsValidAssembly() in /_/src/Compilers/Core/Portable/MetadataReference/AssemblyMetadata.cs:line 410

   at Microsoft.CodeAnalysis.CommonReferenceManager`2.GetMetadata(PortableExecutableReference peReference, CommonMessageProvider messageProvider, Location location, DiagnosticBag diagnostics) in /_/src/Compilers/Core/Portable/ReferenceManager/CommonReferenceManager.Resolution.cs:line 496

   at Microsoft.CodeAnalysis.CommonReferenceManager`2.ResolveMetadataReferences(TCompilation compilation, Dictionary`2 assemblyReferencesBySimpleName, ImmutableArray`1& references, IDictionary`2& boundReferenceDirectiveMap, ImmutableArray`1& boundReferenceDirectives, ImmutableArray`1& assemblies, ImmutableArray`1& modules, DiagnosticBag diagnostics) in /_/src/Compilers/Core/Portable/ReferenceManager/CommonReferenceManager.Resolution.cs:line 321

   at Microsoft.CodeAnalysis.CSharp.CSharpCompilation.ReferenceManager.CreateAndSetSourceAssemblyFullBind(CSharpCompilation compilation) in /_/src/Compilers/CSharp/Portable/Symbols/ReferenceManager.cs:line 357

   at Microsoft.CodeAnalysis.CSharp.CSharpCompilation.ReferenceManager.CreateSourceAssemblyForCompilation(CSharpCompilation compilation) in /_/src/Compilers/CSharp/Portable/Symbols/ReferenceManager.cs:line 184

   at Microsoft.CodeAnalysis.CSharp.CSharpCompilation.GetBoundReferenceManager() in /_/src/Compilers/CSharp/Portable/Compilation/CSharpCompilation.cs:line 1033

   at Microsoft.CodeAnalysis.CSharp.CSharpCompilation.get_SourceAssembly() in /_/src/Compilers/CSharp/Portable/Compilation/CSharpCompilation.cs:line 1257

   at Microsoft.CodeAnalysis.CSharp.CSharpCompilation.get_Assembly() in /_/src/Compilers/CSharp/Portable/Compilation/CSharpCompilation.cs:line 1270

   at Microsoft.CodeAnalysis.CSharp.CSharpCompilation.GetRuntimeMetadataVersion(EmitOptions emitOptions) in /_/src/Compilers/CSharp/Portable/Compilation/CSharpCompilation.cs:line 3394

   at Microsoft.CodeAnalysis.CSharp.CSharpCompilation.GetRuntimeMetadataVersion(EmitOptions emitOptions, DiagnosticBag diagnostics) in /_/src/Compilers/CSharp/Portable/Compilation/CSharpCompilation.cs:line 3376

   at Microsoft.CodeAnalysis.CSharp.CSharpCompilation.CreateModuleBuilder(EmitOptions emitOptions, IMethodSymbol debugEntryPoint, Stream sourceLinkStream, IEnumerable`1 embeddedTexts, IEnumerable`1 manifestResources, CompilationTestData testData, DiagnosticBag diagnostics, CancellationToken cancellationToken) in /_/src/Compilers/CSharp/Portable/Compilation/CSharpCompilation.cs:line 3121

   at Microsoft.CodeAnalysis.Compilation.CheckOptionsAndCreateModuleBuilder(DiagnosticBag diagnostics, IEnumerable`1 manifestResources, EmitOptions options, IMethodSymbol debugEntryPoint, Stream sourceLinkStream, IEnumerable`1 embeddedTexts, CompilationTestData testData, CancellationToken cancellationToken) in /_/src/Compilers/Core/Portable/Compilation/Compilation.cs:line 3062

   at Microsoft.CodeAnalysis.Compilation.Emit(Stream peStream, Stream metadataPEStream, Stream pdbStream, Stream xmlDocumentationStream, Stream win32Resources, IEnumerable`1 manifestResources, EmitOptions options, IMethodSymbol debugEntryPoint, Stream sourceLinkStream, IEnumerable`1 embeddedTexts, RebuildData rebuildData, CompilationTestData testData, CancellationToken cancellationToken) in /_/src/Compilers/Core/Portable/Compilation/Compilation.cs:line 2821

   at Microsoft.CodeAnalysis.Compilation.Emit(Stream peStream, Stream pdbStream, Stream xmlDocumentationStream, Stream win32Resources, IEnumerable`1 manifestResources, EmitOptions options, IMethodSymbol debugEntryPoint, Stream sourceLinkStream, IEnumerable`1 embeddedTexts, Stream metadataPEStream, RebuildData rebuildData, CancellationToken cancellationToken) in /_/src/Compilers/Core/Portable/Compilation/Compilation.cs:line 2778

   at LinqToDB.LINQPad.LinqToDBDriver.GetSchemaAndBuildAssembly(IConnectionInfo cxInfo, AssemblyName assemblyToBuild, String& nameSpace, String& typeName)
---------------------------
OK   
---------------------------

Server added and seems working.

Request - Support for InterBase?

Hi, I would like to know if there is ever going to be any support for InterBase. The reason I ask, is because InterBase is using the Firebird ADO.NET derivers now. It seems like this should be an easy add on. Thanks.

Super!

Thank you very much for this driver!!!
In the DataConnection Options, is there a way to fech/populate only a few tables when loading?
Otherwise I would get only a timeout, in my case (the dbo schema contains too many tables).
Thanks again and keep up the good work! :-)

Sybase.Data.AseClient.AseException: The command has timed out.

   at Sybase.Data.AseClient1.AseCommand.CheckResult(Int32 res)
   at Sybase.Data.AseClient1.AseCommand.Execute(CommandBehavior commandBehavior)
   at Sybase.Data.AseClient1.AseCommand._ExecuteReader(CommandBehavior commandBehavior)
   at Sybase.Data.AseClient1.AseCommand.ExecuteReader(CommandBehavior commandBehavior)
   at Sybase.Data.AseClient.AseCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at Sybase.Data.AseClient.AseConnection.GetSchema(String collectionName, String[] restrictionValues)
   at Sybase.Data.AseClient.AseConnection.GetSchema(String collectionName)
   at LinqToDB.DataProvider.Sybase.SybaseSchemaProvider.GetProcedureParameters(DataConnection dataConnection) in i:\linq2db\Source\DataProvider\Sybase\SybaseSchemaProvider.cs:line 181
   at LinqToDB.SchemaProvider.SchemaProviderBase.GetSchema(DataConnection dataConnection, GetSchemaOptions options) in i:\linq2db\Source\SchemaProvider\SchemaProviderBase.cs:line 188
   at LinqToDB.LINQPad.SchemaAndCodeGenerator.<GetItemsAndCode>d__11.MoveNext() in C:\projects\linq2db-linqpad\Source\SchemaAndCodeGenerator.cs:line 60
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   at LinqToDB.LINQPad.LinqToDBDriver.GetSchemaAndBuildAssembly(IConnectionInfo cxInfo, AssemblyName assemblyToBuild, String& nameSpace, String& typeName) in C:\projects\linq2db-linqpad\Source\LinqToDBDriver.cs:line 225
   at Sybase.Data.AseClient1.AseCommand.CheckResult(Int32 res)
   at Sybase.Data.AseClient1.AseCommand.Execute(CommandBehavior commandBehavior)
   at Sybase.Data.AseClient1.AseCommand._ExecuteReader(CommandBehavior commandBehavior)
   at Sybase.Data.AseClient1.AseCommand.ExecuteReader(CommandBehavior commandBehavior)
   at Sybase.Data.AseClient.AseCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at Sybase.Data.AseClient.AseConnection.GetSchema(String collectionName, String[] restrictionValues)
   at Sybase.Data.AseClient.AseConnection.GetSchema(String collectionName)
   at LinqToDB.DataProvider.Sybase.SybaseSchemaProvider.GetProcedureParameters(DataConnection dataConnection) in i:\linq2db\Source\DataProvider\Sybase\SybaseSchemaProvider.cs:line 181
   at LinqToDB.SchemaProvider.SchemaProviderBase.GetSchema(DataConnection dataConnection, GetSchemaOptions options) in i:\linq2db\Source\SchemaProvider\SchemaProviderBase.cs:line 188
   at LinqToDB.LINQPad.SchemaAndCodeGenerator.<GetItemsAndCode>d__11.MoveNext() in C:\projects\linq2db-linqpad\Source\SchemaAndCodeGenerator.cs:line 60
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   at LinqToDB.LINQPad.LinqToDBDriver.GetSchemaAndBuildAssembly(IConnectionInfo cxInfo, AssemblyName assemblyToBuild, String& nameSpace, String& typeName) in C:\projects\linq2db-linqpad\Source\LinqToDBDriver.cs:line 225

Cannot load "System.Runtime, Version=4.2.1.0, PublicKeyToken=b03f5f7f11d50a3a"

Version: 3.1.0.0
OS: Win 10 x64
I have .NET Framework 4.8, .NET Core 2.1 (SDK), .NET Core 3.1 (Desktop runtime) installed.

It happens when I try to add "typed data context" connection (dll depends on .NET Core 2.1 and linq2db 3.2.3).
What can go wrong?

What format does the connection string use?

using the linqpad driver with postgres and would like to know if it's possible to include ssh tunnel settings in the connection string.

Using SQL syntax when opening an SQLite DB

Hey friends,

I've been trying to use this driver on LINQPad and it works like a charm when using LINQ syntax.
However, when I use the SQL syntax, I get the following error message no matter which table I try to select:

"SQL logic error
no such table: X"
(X being the table I choose)

The schema is properly shown on the left-hand side menu, I made sure that I am using the correct connection, and I tried multiple .NET versions, all ends the same way.

When I right-click on the DB connection, the "Use in current query" button is grayed out, meaning it's already selected.

Screenshot:

Now, an interesting thing to add here, is that all of the above happens on a remote machine I am working with.

In my local PC it works perfectly, and to make matters even more confusing, if I just go ahead and copy the query from my local machine to the remote one, it works perfectly fine. If I type the whole thing from scratch, I'll get an issue again.
Even worse is that if I copy the query from the remote machine and run it on my local machine, I'll start having the issue on my side too.

Both machines are using English(United States) keyboards.

I tried to search the web for this error, but haven't found any posts that followed through.

Does anyone have any suggestions?

Thanks!
Eitan

Support for Azure Cosmos DB

Its a feature request :) EF Core has a driver for Cosmos DB for few years now. It would be great to have this driver available in LinqPad. Cheers,

Sql.Expression attribute not working from MyExtensions in LINQPad

I have this extension method defined in the MyExtensions file in LINQPad:

[LinqToDB.Sql.Expression("({0} IS NULL OR Len({0}) IS NOT NULL AND Len({0}) = 0)", IsPredicate = true)]
public static bool IsNullOrEmpty(this string str) => string.IsNullOrEmpty(str);

However, when I try and use it in another query it doesn't work and I get:
LinqException: 'i.TableProperty.IsNullOrEmpty()' cannot be converted to SQL.

If I move the extension method to the actual query file it works just fine, however.
I do apologize if this isn't the right place for this. I'm not too familiar with attributes, so not sure if this is me misunderstanding something (probably) or something with LINQPad.

Another issue with oracle

https://forum.linqpad.net/discussion/2760/include-oracle-stored-procedures

The type initializer for 'Sap.Data.Hana.Hana.Connector' threw an exception'

Can not use SAP Hana
Fill in Connection string : Servet=xxxxxx:xxxxx and click test results in : The type initializer for 'Sap.Data.Hana.Hana.Connector' threw an exception'

Populating Fails with TimeOut

Here is the log Entry

6.11.11 (X64) 2021-04-20T12:44:25.9842861+05:00 Error opening DataContext
RemoteException - SqlException - Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
Source=Core .Net SqlClient Data Provider

 -System.Data.SqlClient.SqlConnection Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) offset: 0x50
 -System.Data.SqlClient.SqlInternalConnection Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) offset: 0x29
 -System.Data.SqlClient.TdsParser Void ThrowExceptionAndWarning(System.Data.SqlClient.TdsParserStateObject, Boolean, Boolean) offset: 0x157
 -System.Data.SqlClient.TdsParser Boolean TryRun(System.Data.SqlClient.RunBehavior, System.Data.SqlClient.SqlCommand, System.Data.SqlClient.SqlDataReader, System.Data.SqlClient.BulkCopySimpleResultSet, System.Data.SqlClient.TdsParserStateObject, Boolean ByRef) offset: 0x0
 -System.Data.SqlClient.SqlDataReader Boolean TryConsumeMetaData() offset: 0x40
 -System.Data.SqlClient.SqlDataReader System.Data.SqlClient._SqlMetaDataSet get_MetaData() offset: 0x31
 -System.Data.SqlClient.SqlCommand Void FinishExecuteReader(System.Data.SqlClient.SqlDataReader, System.Data.SqlClient.RunBehavior, System.String) offset: 0x92
 -System.Data.SqlClient.SqlCommand System.Data.SqlClient.SqlDataReader RunExecuteReaderTds(System.Data.CommandBehavior, System.Data.SqlClient.RunBehavior, Boolean, Boolean, Int32, System.Threading.Tasks.Task ByRef, Boolean, System.Data.SqlClient.SqlDataReader) offset: 0x33C
 -System.Data.SqlClient.SqlCommand System.Data.SqlClient.SqlDataReader RunExecuteReader(System.Data.CommandBehavior, System.Data.SqlClient.RunBehavior, Boolean, System.Threading.Tasks.TaskCompletionSource`1[System.Object], Int32, System.Threading.Tasks.Task ByRef, Boolean, System.String) offset: 0x79
 -System.Data.SqlClient.SqlCommand System.Data.SqlClient.SqlDataReader RunExecuteReader(System.Data.CommandBehavior, System.Data.SqlClient.RunBehavior, Boolean, System.String) offset: 0x0
 -System.Data.SqlClient.SqlCommand System.Data.SqlClient.SqlDataReader ExecuteReader(System.Data.CommandBehavior) offset: 0x2A
 -System.Data.SqlClient.SqlCommand System.Data.Common.DbDataReader ExecuteDbDataReader(System.Data.CommandBehavior) offset: 0x0
 -System.Data.Common.DbCommand System.Data.Common.DbDataReader ExecuteReader(System.Data.CommandBehavior) offset: 0x0
 -LinqToDB.Data.DbCommandProcessor.DbCommandProcessorExtensions System.Data.Common.DbDataReader ExecuteReaderExt(System.Data.IDbCommand, System.Data.CommandBehavior) offset: 0x19
 -LinqToDB.Data.DataConnection System.Data.IDataReader ExecuteReader(System.Data.IDbCommand, System.Data.CommandBehavior) offset: 0x0
 -LinqToDB.Data.DataConnection System.Data.IDataReader ExecuteReader(System.Data.CommandBehavior) offset: 0x96
 -LinqToDB.Data.CommandInfo System.Collections.Generic.IEnumerable`1[T] Query[T]() offset: 0x45
 -LinqToDB.Data.DataConnectionExtensions System.Collections.Generic.IEnumerable`1[T] Query[T](LinqToDB.Data.DataConnection, System.String) offset: 0x7
 -LinqToDB.LINQPad.LinqToDBDriver System.Nullable`1[System.DateTime] GetLastSchemaUpdate(LINQPad.Extensibility.DataContext.IConnectionInfo) offset: 0x2D


   INNER: Win32Exception - The wait operation timed out.
   
   (no stack trace)
Source=System.Private.CoreLib

 -System.Runtime.ExceptionServices.ExceptionDispatchInfo Void Throw() offset: 0x11
 -System.Runtime.CompilerServices.TaskAwaiter Void ThrowForNonSuccess(System.Threading.Tasks.Task) offset: 0x27
 -System.Runtime.CompilerServices.TaskAwaiter Void HandleNonSuccessAndDebuggerNotification(System.Threading.Tasks.Task) offset: 0x28
 -System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1+ConfiguredTaskAwaiter TResult GetResult() offset: 0xB
 -LINQPad.DataContextManager+<FetchDCInfoCore>d__31 Void MoveNext() offset: 0x30A


First Chance Data:
   -System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() offset=0x11

Use relaxed dependency check for .NETFramework version

Installation on .NETFramework 4.6.1 / 4.7.2 failed

Could not install package 'linq2db.LINQPad 3.3.3'. You are trying to install this package into a project that targets '.NETFramework,Version=v4.7.2', but the package does not contain any assembly references or content files that are compatible with that framework. For more information, contact the package author.

MS Access

Describe your issue.

If you have a question, first try to check our documentation, especially FAQ and search in issues and discussions - maybe your question already answered there.

If you still have questions or want to start general discussion, please create new topic in discussions.

If you are seeing an exception, include the full exceptions details (message and stack trace).

Exception message:
Stack trace:

Error instantiating type MSAccessDataContextDriver.MSAccessDataContextDriver in C:\AppData\Local\LINQPad\Drivers\DataContext\NetCore\MSAccessDataContextDriver\MSAccessDataContextDriver.dll
  - Driver assembly targets .NET Framework. Your driver assembly must target .NET Core.   at LINQPad.Extensibility.DataContext.DriverProxy.Instantiator.Instantiate(String assemblyPath, String typeName, String internalID)

### Steps to reproduce
Try to open an existing connection from LinqPad 6.
Error message.

```c#
<code with error and mapping classes>

Environment details

linq2db version: 4.1.0.0
Database Server: MS Access
Database Provider: Microsoft Access (ODBC)
Operating system: Windows 10
.NET Framework: 4.6

NRE in OracleSchema provider

https://forum.linqpad.net/discussion/2741/linq-to-db-oracle-connection-successful-but-population-fails

Would be hard to track it down. Looks like stack trace is optimized: GetSchema cannot throw this exception and I don't see currently how it could fail in called methods.

SQL vs C# Language differences in table and query names

I have discovered after upgrading the Linq To DB driver to version 5 that all of my database queries that reference a table name or field name containing an underscore character are broken and require modification to work.

I have found that when displaying the table names and fields in the Database browser (left top panel in LINQPad) while the SQL Language option is chosen, the fields have the expected (unmodified) names. Selecting any language option other than SQL displays modified entity names.

This breaking change should be behind an option. Please provide the ability restore the original operationality, honoring the entity names as per defined the database schema.

Question - Connection settings for context from assembly

I'm trying to load a data context from an assembly using LinqPad6. In the dialog I am specifying an appsettings.json file but no matter what I enter, when I try to use the context I'm getting an exception that Configuration 'Default' is not defined.

What should the structure of the settings file be to configure this?

LinqPad6
Linq2DB LinqPad driver 3.1.0.0

Migrate to new scaffold framework for model generation from old T4-based code

IBM.Data.DB2.iSeries DLL

Any thoughts on this?

Can't run SQL against MS Access (unable to obtain a DbFactory)

I posted this on the LinqPad forum as well, because I'm not sure if it's a limitation of LinqPad or an issue with this driver.

When I make a connection to an MS Access db (either OleDb or ODBC), I'm able to test the connection successfully, I'm able to expand the connection node and see all the tables, and I'm able to run C# code using the connection. But if I choose SQL as the language and try to execute a straight query, I get an error, "Unable to obtain a DbFactory for the connection."

Add non-persistent connection string option and LinqPad password manager support

See https://forum.linqpad.net/discussion/2917/best-practice-for-storing-connection-string-outside-of-linqpad-file discussion

sproc parameter named ret error.

I think it is the same issue as in https://github.com/linq2db/t4models/issues/16
I've tried to connect to my database and got the following error:

System.Exception: (2029,11): error CS0136: A local or parameter named 'ret' cannot be declared in this scope because that name is used in an enclosing local scope to define a local or parameter

at LinqToDB.LINQPad.LinqToDBDriver.GetSchemaAndBuildAssembly(IConnectionInfo cxInfo, AssemblyName assemblyToBuild, String& nameSpace, String& typeName) in C:\projects\linq2db-linqpad\Source\LinqToDBDriver.cs:line 257
at LinqToDB.LINQPad.LinqToDBDriver.GetSchemaAndBuildAssembly(IConnectionInfo cxInfo, AssemblyName assemblyToBuild, String& nameSpace, String& typeName) in C:\projects\linq2db-linqpad\Source\LinqToDBDriver.cs:line 257

LINQPad 5 AnyCPU error - BadImageFormatException on IBM.Data.DB2.dll

Windows 10 64-bit.

If using LINQPad 5 - linq2db plugin works fine.
if using LINQPad 5 AnyCPU - linq2db plugin throws exception

I think this happens because IBM.Data.DB2.dll has platform target x86
If I open IBM.Data.DB2.dll from Redist folder in this repositiry in JetBrains dotPeek, I can see picture

So I think linq2db plugin should provide two versions on IBM.Data.DB2.dll - x86 and x64 bit editions.
You can do this using bindingRedirect feature.

Add ClickHouse support

Error when reading Guid from Sql Azure.

I am trying to dump the results of a view, that view contains a column of type Guid ( sql type uniqueidentifier ) and so linqpad throws me this error:

I was inspecting the object and i was seeing that its sql type is as nvarchar(36) and the property type is string.

How can i set a custom mapping for this like its done in the Linq2Db, example.

LinqPad 5

The issue is in linqpad5 a query with left join is performaing a weird inner join and adding a new ref to the left side of the join instead of using the alias defined for the left side of the table.

This is my query

	var persistedDomainEvent = (from p in PersistedDomainEvent
								from c in DomainEventConsumptionLogEntry.LeftJoin(c => p.Id == c.PersistedDomainEvent.Id )
								//where p.ScheduledTimeUtc >= pastTime && p.ScheduledTimeUtc <= futureTime
								//&& p.DomainEventJson.Contains("540593036")
								orderby p.ScheduledTimeUtc descending

								select new { p, c }).Take(1000);

and this is whats output

--  SqlServer.2008
SELECT TOP (1000)
	[t2].[Id],
	[t2].[CausingCommand],
	[t2].[RaisedTimeUtc],
	[t2].[ScheduledTimeUtc],
	[t2].[DomainEventType],
	[t2].[DomainEventJson],
	[t2].[Priority],
	[c1].[Id] as [Id1],
	[c1].[ConsumedTime],
	[c1].[CompletedTime],
	[c1].[Consumer],
	[c1].[Failures],
	[c1].[PersistedDomainEvent_id],
	[c1].[FailureRerunEventId]
FROM
	[dbo].[PersistedDomainEvent] [t2]
		LEFT JOIN [dbo].[DomainEventConsumptionLogEntry] [c1]
-->>>>>>>>>>>>>>>weird stuff happening here
			INNER JOIN [dbo].[PersistedDomainEvent] [t1] ON [c1].[PersistedDomainEvent_id] = [t1].[Id]
		ON [t2].[Id] = [t1].[Id]
ORDER BY
	[t2].[ScheduledTimeUtc] DESC

Should it be

LEFT JOIN [dbo].[DomainEventConsumptionLogEntry] [c1] ON [c1].[PersistedDomainEvent_id] = [t2].[Id]

Upgrade dependency Azure.Identity package

GHSA-5mfx-4wcx-rv27

not thread safe?

Parallel.ForEach(rdbList, new ParallelOptions() { MaxDegreeOfParallelism = 4 }, (rdb, loopState) =>
{
	this.Insert(new test
			{
				Guid = guid,
				DataChange_LastTime = DateTime.Now,
			});
});

err:

Cannot set MySqlCommand.CommandText when there is an open DataReader for this command; it must be closed first.

Error in GetSchemaAndBuildAssembly

When opening a connection I am getting the following exception.

I'm debugging from the latest Linq2DB.LINQPad master branch and this is just one of many exceptions but it is the only one that is displayed.

The line of generated code that this refers to is:

public ITable<@@__MigrationLog> @@__MigrationLogs { get { return this.GetTable<@@__MigrationLog>(); } }
This is connecting to an SQL Server database but I get similar issues when connecting to iSeries. A different SQL database doesn't give any issues but it only has a few tables and is very simple.

This is related to but different from #15

Error instantiating type LinqToDB.LINQPad.LinqToDBStaticDriver in C:\Users\bea\AppData\Local\LINQPad\Drivers\DataContext\NetCore\linq2db.LINQPad\linq2db.LINQPad.dll
  - Driver assembly targets .NET Framework. Your driver assembly must target .NET Core 3.   at LINQPad.Extensibility.DataContext.DriverProxy.Instantiator.Instantiate(String assemblyPath, String typeName, String internalID)

Error instantiating type LinqToDB.LINQPad.LinqToDBDriver in C:\Users\bea\AppData\Local\LINQPad\Drivers\DataContext\NetCore\linq2db.LINQPad\linq2db.LINQPad.dll
  - Driver assembly targets .NET Framework. Your driver assembly must target .NET Core 3.   at LINQPad.Extensibility.DataContext.DriverProxy.Instantiator.Instantiate(String assemblyPath, String typeName, String internalID)

linq2db / linq2db.linqpad Goto Github PK

linq2db.linqpad's People

Contributors

Stargazers

Watchers

Forkers

linq2db.linqpad's Issues

Environment details

Recommend Projects

Recommend Topics

Recommend Org