EFCore.Snowflake 8.0.3

About

EntityFrameworkCore.Snowflake is the Entity Framework Core (EF Core) provider for Snowflake.

It is build on top of Snowflake.Data.

How to Use

public class Startup
{
    public void ConfigureServices(IServiceCollection services)
    {
        // Replace with your connection string.
        var connectionString = "account=YOUR_ACCOUNT;host=UR_HOST.us-east-1.snowflakecomputing.com;user=UR_USER;password=UR_PASSWORD;db=TESTDB;schema=PUBLIC;warehouse=UR_WAREHOUSE";

        // Replace 'YourDbContext' with the name of your own DbContext derived class.
        services.AddDbContext<YourDbContext>(
            dbContextOptions => dbContextOptions
                .UseSnowflake(connectionString)
        );
    }
}

Scaffolding

If you wish to create model from existing Snowflake database, then follow this steps. Provider name is EFCore.Snowflake. Ensure you have ef tools installed (dotnet tool install --global dotnet-ef).

Feedback

Feel free to submit any feedback - bug reports or feature requests. All feedback is welcome at GitHub repository.

Key Features

• Query support
• Auto increment
• Scaffolding support
• Database versioning support

Known issues

• Spatial types not supported
• Variant type inserts data with json escaping (bug in Snowflake.Data connector)
• Database name is required to be named UPPERCASE (bug in Snowflake.Data)
• More advanced queries, such as LEFT LATERAL JOIN or more complex subqueries fails, because they are not supported by Snowflake right now

Related Packages

• Other Packages
  • Snowflake ADO.NET connetor Snowflake.Data.
  • Microsoft.EntityFrameworkCore

License

EntityFrameworkCore.Snowflake is released as open source under the GNU Lesser General Public License v3.0 only.