-2

I'm creating an application with C# using SQL Server. I would like to know if it's possible to run the app on a computer which has no SQL Server. My database extension is .mdf

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
  • 2
    I'd suggest reading up on SQL Server Express. – mjwills Apr 15 '19 at 12:54
  • 1
    Also look for local database – Code Name Jack Apr 15 '19 at 12:55
  • 3
    To use and work with an .mdf file you need Sql Server, but there are many flavours of Sql Server. There is the simple LocalDb version that you can install without using the full fledged Sql Server service. You can read something about LocalDB here https://stackoverflow.com/questions/9655362/localdb-deployment-on-client-pc – Steve Apr 15 '19 at 12:55
  • Alright. Thanks for all. –  Apr 15 '19 at 14:30

1 Answers1

1

Using a .mdf file on PC without installing SQL Server or SQL Server Express is not possible. LocalDB version also requires LocalDB deployment.

However, you can use .sdf file but it does not support stored procedures. For this, you need to supply necessary dll files in the app folder.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
GL SOFT INDIA
  • 64
  • 1
  • 10
  • 1
    `.sdf` is SQL Server **CE** (Compact Edition), which is no longer supported by Microsoft, unfortunately. – marc_s Apr 15 '19 at 13:56