SQLite connections do not give access to VIEWs

fsprojects / SQLProvider

A general F# SQL database erasing type provider, supporting LINQ queries, schema exploration, individuals, CRUD operations and much more besides.

https://fsprojects.github.io/SQLProvider

Other

572 stars 146 forks source link

SQLite connections do not give access to VIEWs #591

Closed ThomasRizzo closed 5 years ago

ThomasRizzo commented 5 years ago

https://github.com/fsprojects/SQLProvider/blob/dd36be45491fa377184bc408248a3b9cd49a3597/src/SQLProvider/Providers.SQLite.fs#L76

I'm not able to access sqlite views. Can they be added by simply appending OR type ='view' to the query in customGetSchema? (I'm new to both F# and SQLProvider). Thanks

Thorium commented 5 years ago

Good finding, I didn't even know SQLite supports views...

Are you using .NET Core (or Standard), or are you using Mono or .NET Framework full?

ThomasRizzo commented 5 years ago

I'm mostly using .NET Framework

Thorium commented 5 years ago

Ok, this seems important issue let me fix it right away...

Thorium commented 5 years ago

Fixed in Nuget package 1.1.56. It'll take a minute from NuGet to update its servers.

ThomasRizzo commented 5 years ago

Works great, thanks!