英文:

F# Type Provider for postgresql raw queries compatible with .NET6+?

问题

I realize there's similar questions about this on SO however a lot of them are over 5 years old, and the projects they're referring to have since gone stale. For instance this project seems exactly what I'm looking for, but it's no longer maintained.

我意识到Stack Overflow上有类似的问题，但其中许多问题已经超过5年了，它们所指的项目现在已经停止维护。例如，这个项目似乎正是我正在寻找的，但它不再维护。

I'm wondering if there's an actively maintained F# type provider for postgresql raw sql queries? Something like dapper/npgsql but with type provider support (ie: realtime intellisense type checking against the db schema, etc)?

我想知道是否有一个活跃维护的F#类型提供程序，用于postgresql原始SQL查询？类似于dapper/npgsql，但支持类型提供程序（即：实时智能感知类型检查与数据库架构相匹配等）？

From my research SQL Provider seems to be actively maintained and supports postgresql, however it looks to be for ORM, and not raw SQL queries.

根据我的研究，SQL Provider似乎是在积极维护，并支持postgresql，但看起来是用于ORM，而不是原始SQL查询。

I'd go ahead and help maintain an outdated project but I'm just learning F# and following a book ("Get Programming with F#") that has just introduced me to type providers. The examples in the book are useful for the CSV & HTML providers however unfortunately the book is outdated with the SQL type providers shown, thus I'm in the process of still trying to actually understand how they work.

我愿意继续帮助维护一个过时的项目，但我只是在学习F#，并且正在按照一本介绍我类型提供程序的书籍（"Get Programming with F#"），这本书刚刚让我了解了类型提供程序。书中的示例对于CSV和HTML提供程序非常有用，但不幸的是，该书中显示的SQL类型提供程序已过时，因此我仍在努力理解它们的工作原理。

So in essence my question is, is there a type provider for F# raw sql postgresql queries compatible with .NET6+?

因此，实质上我的问题是，是否有一个适用于.NET6+的F#原始SQL postgresql查询的类型提供程序？

英文:

I realize there's similar questions about this on SO however a lot of them are over 5 years old, and the projects they're referring to have since gone stale. For instance this project seems exactly what I'm looking for, but it's no longer maintained.

I'm wondering if there's an actively maintained F# type provider for postgresql raw sql queries? Something like dapper/npgsql but with type provider support (ie: realtime intellisense type checking against the db schema, etc)?

From my research SQL Provider seems to be actively maintained and supports postgresql, however it looks to be for ORM, and not raw SQL queries.

I'd go ahead and help maintain an outdated project but I'm just learning F# and following a book ("Get Programming with F#") that has just introduced me to type providers. The examples in the book are useful for the CSV & HTML providers however unfortunately the book is outdated with the SQL type providers shown, thus I'm in the process of still trying to actually understand how they work.

So in essence my question is, is there a type provider for F# raw sql postgresql queries compatible with .NET6+?

答案1

得分: 1

我们在这里有一个“可工作”的 Rezoom.SQL 分支：https://github.com/valora-digital/Rezoom.SQL

没有针对它的 NuGet 包，但你可以直接将其包含在你的 .Net6 解决方案中并引用它，它将正常工作。我们尚未对其进行进一步更新。我对它的长期计划是重命名整个项目，并为其创建一个新的 NuGet 包，因为我们无法联系到原始维护者以获取对现有 NuGet 的写入访问权限。

英文:

We have a "working" fork of Rezoom.SQL here: https://github.com/valora-digital/Rezoom.SQL

There's no NuGet package for it, but you can include it directly in your .Net6 solution and reference it, and it will work as it should. We haven't updated it beyond that yet. My long term plan with it is to rename the entire project, and create a new NuGet for it as we can't get ahold of the original maintainer to get write access to the existing NuGet.