How to access Snowflake Database from .Net application using Entity Framework 6

user_14234498 0
Viewed 1241

I am building an ASP.NET application which accesses Snowflake database for getting table data. I have added connection string as below and also added database context class.

<connectionStrings>
    <add name="SnowflakeContext" 
         connectionString="Offline=False;URL=XXXXXXXXX.snowflakecomputing.com;User=XXXXX;Password=XXXXX;Server=localhost;Database=DEMO_DB;Warehouse=COMPUTE_WH;Account=SYSADMIN;" 
         providerName="System.Data.CData.Snowflake" />
</connectionStrings>
<entityFramework>
    <providers>
        <provider invariantName="System.Data.CData.Snowflake" 
                  type="System.Data.CData.Snowflake.SnowflakeProviderServices, System.Data.CData.Snowflake.Entities.EF6" />
    </providers>
</entityFramework>

I want to show the data from snowflake database table on an .aspx page using Entity Framework. I tried creating a grid view control and while adding data source I only get SQL Server and I don't get Cdata Snowflake. I have even installed Snowflake.data package from NuGet. Can someone help me here?

snowflake-cloud-data-platform entity-framework webforms c#
1 Answers

I'm not a C# programmer but I think you'll probably need to install the Snowflake ODBC driver and then connect up the grid view to an ODBC data source (see the second example on this page).

user_462390
Related