'Publish WPF Application with localdb without click-once

i am a absolute beginner... and it is my first database based application.

i would like to drop a c# wpf application with database (2 tables) on an offline single-user-client. its a wpf c# ef6 code first app. on my machine with vs2019 it runs as intended. now trying to run it on a new set up win10 machine it doesnt even start.

  • net 4.7.2 is installed
  • sql server 2016 localdb is installed manually (.msi)

Here is the connectionString for my db:

<connectionStrings>
<add name="ZuschnittverwaltungDB" connectionString="data source=(LocalDb)\MSSQLLocalDB;AttachDbFilename=|Datadirectory|\ZuschnittverwaltungDB.mdf;initial catalog=Zuschnittverwaltung.ZuschnittverwaltungDB;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework" providerName="System.Data.SqlClient" />

i assume that i am missing a big point but i cant find any solution after searching several days...

Edit1:

AttachDbFilename=|Datadirectory|\ZuschnittverwaltungDB.mdf ->

AppDomain.CurrentDomain.SetData("DataDirectory", Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().Location));

i am thankfully for every approach.

c++sharpwpfentity-framework-6ef-code-firstlocaldb


Solution 1:[1]

It seems that everything i did first was right. Didnt changed the code or installed anything new.

just ran cmd-> sqllocaldb delete mssqllocaldb

copied the databasefiles from my pc to the specified folder and it worked...

Thanks @mm8. I could find more ErrorInformations in the windows event manager

cheers

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 forsit66

Related Questions