8000 Bring dotnet glob to sql clr and ef core! · Issue #69 · dazinator/DotNet.Glob · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content
Bring dotnet glob to sql clr and ef core! #69
Open
@dazinator

Description

@dazinator

I'm considering the following..

Produce a SQL Clr assembly that can be installed into sql server and adds a User defined function for glob matching which will leverage dotnet glob.

Produce an EFCore assembly that provides the User defined function for use with EFCore db context queries.

See this for how to use user defined functions in ef core: http://anthonygiretti.com/2018/01/11/entity-framework-core-2-scalar-function-mapping/

With this in place, in an application that uses EFCore, you could query a SQL database and use Glob pattern matching inside the query that executes on the sql server. You can already use Like operator ofcourse, but Glob expressions have the potential to be better suited for matching paths if you store directory paths in a database for example.

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions

      0