Skip to Content
0

Does .net client support entity framework 6 code first migrations?

Jun 05, 2017 at 11:00 AM

79

avatar image

I have SAP HANA 2 Express XSA SPS01 vm up and running.

I installed the client package on my Windows 10 pc with VIsual Studio 2015 Professional Update 3.

hdbsql client works from command line, and C:\Program Files\sap\hdbclient has been added to the PATH env variable.

All the Demo apps (DemoSetup, SyncViewer, TableEditor, TableViewer) compile and work correctly.

Then I tried to build a simple mvc web app with EF 6.

An entry for Sap.Data.Hana.v4.5 is present under "References", and it is version 2.1.37.0

When I run "Enable-migrations" I get the dreaded "

System.IO.FileNotFoundException: cannot find libSQLHDBCHDB.dll
   in Sap.Data.Hana.HanaUnmanagedDll.SearchNativeDlls(String regKeyName)

I checked the registry and I have two keys in

HKLM/Software/ODBC/ODBCINST.INI/HDBODBC

Driver = C:\Program Files\sap\hdbclient\libodbcHDB.dll
Setup = C:\Program Files\sap\hdbclient\libodbcHDB.dll

libSQLHDBCHDB.dll is present in C:\Program Files\sap\hdbclient

How can these keys work for ado.net? WHere is the trick, if any, to have EF migrations work?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers