search

linq2db / linq2db.LINQPad

linq2db.LINQPad is a driver for LINQPad.
MIT License
74 stars 23 forks source link

Upgrade linq2db.LINQPad support LINQPad 8 #96

Closed kkbruce closed 10 months ago

kkbruce commented 10 months ago

LINQPad 8 is RTM, Upgrade linq2db.LINQPad to support LINQPad 8.

MaceWindu commented 10 months ago

What exactly should be upgraded? Do you have any issues with current release in linqpad 8?

kkbruce commented 10 months ago

@MaceWindu

Connection is not working.

Run a docker ms-sql container.

https://learn.microsoft.com/zh-tw/sql/linux/quickstart-install-connect-docker?view=sql-server-ver16&pivots=cs1-bash

Use connectionString Server=localhost;Database=master;User Id=SA;Password=<YourStrong@Passw0rd>; test by LINQPad 8 got error message:

image

image

image

image

MaceWindu commented 10 months ago

That has nothing to do with linqpad8. Your connection lacks SSL configuration. I have no idea what eror exactly you have but you could try to add TrustServerCertificate=True or Encrypt=False to your connection string

viceroypenguin commented 10 months ago

@kkbruce I can confirm that LinqPad 8 is working with the existing driver and MSSQL: image

Like @MaceWindu said, add Encrypt=false; to your connection string and you should be able to access the docker MSSQL server.

kkbruce commented 10 months ago

TrustServerCertificate=True and Encrypt=False is working.