I'm using dotConnect for SQLite with EF 6.1 and EF migrations.
Is it possible (and how) to define a SQLiteScalarFunction which then could be called in the SQL code which is executed via DbMigration.Up when running the migration?
CAn SQLiteScalarFunction be used in DbMigration?
Re: CAn SQLiteScalarFunction be used in DbMigration?
1. Create the SQLiteConnection object.
2. Register your function in the conn.StateChange event handler when State changes from Closed to Opened: https://www.devart.com/dotconnect/sqlit ... ction.html.
3. Pass your connection object to constructor of the context for EF migration.
2. Register your function in the conn.StateChange event handler when State changes from Closed to Opened: https://www.devart.com/dotconnect/sqlit ... ction.html.
3. Pass your connection object to constructor of the context for EF migration.