when I create the database from the model in the edmx file, it queries the data source and generates the sql file and adds the data source to app.config
if I select sqlserver as the source, it works fine and I can either use the existing database or create a new one and the tables will be full and ready to use
is it possible for this sql to somehow fill in the new mdf file?
SET QUOTED_IDENTIFIER OFF;
GO
USE [test];
GO
IF SCHEMA_ID(N'dbo') IS NULL EXECUTE(N'CREATE SCHEMA [dbo]');
GO
...
works fine with sqlserver, but complains that the database was not found when connecting to sqlexpress and filling in the local mdf file in the project directory <
Do I need to use the connection string from app.config somehow? or first create a database in sql manager? or in any way change the generated sql (possibly from the path of my created mdf)?
Many thanks