## Where communities thrive

• Join over 1.5M+ people
• Join over 100K+ communities
• Free without limits
##### Activity
• Mar 18 21:49
estensen commented #645
• Mar 17 20:42
voroninp commented #512
• Mar 13 03:56
moviezhou commented #490
• Mar 02 22:56
aggieben closed #637
• Mar 02 22:56
aggieben commented #637
• Feb 29 15:59
nesteg closed #672
• Feb 29 08:48
nesteg commented #672
• Feb 29 08:45
nesteg opened #672
• Feb 28 09:04
tforkmann commented #645
• Feb 28 08:54
isaacabraham commented #645
• Feb 28 08:06
tforkmann commented #645
• Feb 28 07:43
aggieben commented #645
• Feb 27 12:07

Thorium on master

Unit-test to display limit on G… (compare)

• Feb 26 14:22

Thorium on master

docs update (compare)

• Feb 26 13:58

Thorium on 1.1.84

• Feb 26 13:57

Thorium on master

Seq.sumQuery, Seq.maxQuery, ...… (compare)

• Feb 26 12:58

Thorium on master

more key columns support to gro… Merge pull request #671 from Th… (compare)

• Feb 26 12:58
Thorium closed #671
• Feb 26 01:52
daniellittledev edited #669
• Feb 26 01:52
daniellittledev edited #669
Tuomas Hietanen
@Thorium
@nicholas-peterson check that you don't do any kind of Seq.toList before unions. Unions within IQueryabes should generate a single query
(query {...}).Union(query{...})
@nojaf left joins are supported via custom operator syntax (!!) in foreign key relations: for prod in (!!) od.main.Products by ProductID do
Florian Verdonck
@nojaf
@Thorium thx, I'll try this.
brettrowberry
@brettrowberry
Oracle’s ODP.NET Core beta 2 is out. Has anyone tried it out with SQLProvider? http://www.oracle.com/technetwork/topics/dotnet/downloads/odpnetcorebeta-4077982.html
Tuomas Hietanen
@Thorium
One problem with Oracle is that there are no public databases available just to test things quickly.
Tim Forkmann
@tforkmann
@Thorium Hi I found a way to not use the complicated hack to use sqlprovider for netstandard. You basically only need to reference FSharp.Compiler.Tools
Tuomas Hietanen
@Thorium
have you documented anything related to that to anywhere? :-)
How can I inspect the schema with SqlProvider? For example get the column names of a specific table?
Tim Forkmann
@tforkmann
@Thorium I could create a minial project for that
Florian Verdonck
@nojaf
A bit on an odd situation here, I'm connecting to mysql running in a docker container. VS & Rider can both build my project but the connection is not working from the command line. Any suggestions?
Florian Verdonck
@nojaf
error FS3033: The type provider 'FSharp.Data.Sql.SqlTypeProvider' reported an error in the context of provided type 'FSharp.Data.Sql.SqlDataProvider,DatabaseVendor="3",ConnectionString="Server=localhost;Port=3306;Database=rds2016;Uid=root;Pwd=computer;charset=utf8;",ResolutionPath="C:\\Users\\nojaf\\Projects\\barcelona-express-18\\src\\Teams/connectorTemp",UseOptionTypes="True"', member 'GetDataContext'. The error: Unable to cast object of type 'clo@7460-120' to type 'System.Reflection.IReflectableType'.
Florian Verdonck
@nojaf
Nevermind, had a wrong path in my <FscToolPath>
talbottmike
@talbottmike
Is there a known limit to the number of joins in a single query? I seem to consistently run into trouble when attempting more than 6 joins.
Florian Verdonck
@nojaf
I believe it is about that number, has something to do with the max count in generic tuples.
talbottmike
@talbottmike
Thx. That makes sense based on the error msg
I ended up breaking it up into 2 queries to minimize the # of joins
per query
Tuomas Hietanen
@Thorium
Any SQLProvider experts looking for a job?
Tuomas Hietanen
@Thorium
@talbottmike, I just fixed the more-than-6 joins.
talbottmike
@talbottmike
@Thorium Thanks. Was just looking at your release notes earlier today and noticed that.
Hi, I just opened an issue and I was wondering if someone could help me on here, because I'm stumped. I'm trying to connect to a mySQL database, and I keep getting an error saying "Could not load file or assembly 'System.Memory, Version=4.0.1.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51' or one of its dependencies." There's a picture contained in my issue, and I'm on Ubuntu running Rider. Could anyone help me with this?
Peter360
@Peter360
@nojaf did you resolve the issue : The type 'String' is required here and is unavailable. You must add a reference to assembly 'System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e'. I'm also getting this?
Florian Verdonck
@nojaf
Hmm yeah rings a bell, I believe you also have that typeprovider fix?
That was my problem, ask of f# move to different folder, props file was invalid
Peter360
@Peter360
do I still need to use 1.1.18 for netcoreapp2.1 or can i use the latest version of SQLProvider?
Florian Verdonck
@nojaf
Hmm, no idea
Peter360
@Peter360
kk..thanks
Tuomas Hietanen
@Thorium
have you tried the myEntity.SetColumn("ColName", None) or myEntity.SetColumn("ColName", null) ?
Tuomas Hietanen
@Thorium
@Peter360 the latest (1.1.61) should do.
Dharmaturtle
Hi! I can't seem to find any documentation on how transactions work. In particular, coming from an Entity Framework background, I'm used to my Context being disposable, but that doesn't seem to be the case with SQLProvider. What is good practice with respect to calling .GetDataContext()? Thanks!
Dharmaturtle
I found my answer here https://github.com/fsprojects/SQLProvider/issues/112#issuecomment-123086153
I'll submit a PR to the docs, I think it should be in a more prominent position
Kevin Lanthier
@klanthier
I've been playing around with so many versions, is there an actual workaround to that ?
Tuomas Hietanen
@Thorium
the problem is that your DB connection driver is using that, the connection driver is read with reflection, and for .NET reflection to work, the dlls have to be in a single place, not in nuget cache.
Vincent B.
@evilz
Hi all
I try to make the provider work with netcore 3
but I got this error FS3033: The type provider 'FSharp.Data.Sql.SqlTypeProvider' reported an error: Could not load file or assembly 'System.Data.SqlClient, Version=4.6.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
I added the specific version in project but it still not good <PackageReference Include="System.Data.SqlClient" Version="4.6.0" />
Tuomas Hietanen
@Thorium
the Nuget package reference is not enough, dll has to be near in the ResolutionPath
DavidSSL
@DavidSSL
Hey guys, I am on Windows 10 box and I would like to get SQLProvider to work for Postgres. (I was able to get it to work form MSSQL). I followed the instructions here https://github.com/fsprojects/SQLProvider/tree/master/tests/SqlProvider.Core.Tests/Postgres using .net core 3.0.100 but then found dotnet/fsharp#6326. However, I still experience the same problem despite trying the various workarounds suggested.
Are there any up to date instructions on how to get this working?
Tonino Lucca
@tonyx
@DavidSSL the "hack" I found is referencing in the sources a specific version of Npgsql.dll different from the one referenced in the .fsproj. I mean, this is how I do set the resolution path: let [<Literal>] resPath = "/Users/someUser/Projects/orderssystem_core/packages/Npgsql.2.2.1/lib/net45/" , whereas the .fsproj has this reference <PackageReference Include="Npgsql" Version="4.0.7" />. Seems strange but that's it, for now. (see all in this file just in case: https://github.com/tonyx/orderssystem_core/blob/master/Db.fs)
DavidSSL
@DavidSSL
@tonyx . Thanks for your help.
Tonino Lucca
@tonyx
@DavidSSL Did it fix the problem?
DavidSSL
@DavidSSL
@Antonio it didn't work for me. However, I was able to get it working from the following information: https://github.com/fsprojects/SQLProvider/issues/575#issuecomment-506334010
Paul Agron
@nimzi
I'm using NetCore 2.2 on a mac and having difficulty even building with SQLProvider dependencies
Wondering if folks have experience in this area they might share. Does it really work?
Tonino Lucca
@tonyx
@nimzi Is db up and running when editing/compiling?