How to Create Setup.exe in Visual Studio 2019 with SQL Database | FoxLearn

[@nelsonrivers8546]

Can you create a video to show "How to Create Setup.exe in Visual Studio 2022 with EF Core 7.0 or 8.0 ?

[@KengSouth]

Hi fox,I built a little softaware in c# .I'm not so experienced.My question is: "Can yo do a tuto where you create an app with sqlite database an create setup for it with the intergrated sqlite database

[@mikeb6006]

a) Where the .mdf file will installed after setup is finished? b) To run the appliction, it is necessary MSSQLServer Express is installed on the computer? c) Do i need a license if i sell an application with included mdf database? Thanks for your useful videos! Very often they helped!

[@gudgolfer]

Hi Many thanks for a nice tutorial. However, I have one question: When I install the setup.exe in another computer or laptop, do I need to install sqlserver in that machine? Kind regards VENU

[@ahmedzubaca4755]

Is this procedure applicable to .Net CORE?

[@ejdelara2460]

will this also apply if I had made my database in xampp sql?

[@jeffersoneener9071]

Is the Setup Project used for building C++ win form apps?

[@HarshadCodes]

Thank you for making informative video. We need your help for following scenario.. how to make exe file in following case if the source code Front end is developed in visual studio 8 and backend API is developed in visual studio 2013.

[@Mycotta01]

hi, I'm working with postgresql how to create .exe setup with postgresql? Thanks

[@foxlearn]

OK. Thank you for your suggestion. I'll make tutorial soon

[@edsonferraz1]

Hi!! Please, do you have a vídeo to create a setup.exe of aplication with database SQL Server Express? not local.

[@sushilsinghal6387]

Thank you so much for this. This is such a basic thing but no one tells about it. I hope I can someday contribute to people and KZbin.

[@foxlearn]

You're welcome. Thank you so much !

[@ashtonmalakai8674]

i know Im asking randomly but does anybody know a trick to get back into an Instagram account..? I was dumb forgot my account password. I would love any tricks you can give me!

[@raniradcliff4718]

I followed this tutorial for my console application. When I deploy it to another computer, I receive an error when attempting to access the database: C:....\AppDatabase.mdf cannot be upgraded because it is read-only, has read-only files or the user does not have permissions to modify some of the files. Make the database or files writeable, and rerun recovery. An attempt to attach an auto-named database for file C:\Program Files (x86)|....\AppDatabase.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share."

[@mdziaulhaq2576]

Hi your explanation is good.... I created desktop application with service basedatabase,when I try to install it is another system I am getting this error :- The database 'ProjectsV12' cannot be opened because it is version 782 This server supports version 706 and earler. A downgrade path is not supported.

[@kamelsoltani3935]

I get the same problem

[@MuteebQ]

I get the same error in 2023 😢. Did you find a solution?

[@arambahram2967]

On this way, if i update my program to client, does the database will be reset ?

[@toilahoang7466]

can I run this setup.exe on another computer I tried but failed

[@rv9570]

But what the meaning of this all if can't save those data and recall it on form when I next time open it. It seems unusable thing. Is there a way to save this data ?

[@djamelboukhedir2000]

Please is this available for c++ in visual studio 2022?

[@boujaoudkamal3727]

Hello; I have an issue when i change the computer the data base are inknown Can you please help me

[@edgareldy]

Hello FoxLearn. Would you mind posting a video about creating a setup.exe video in visual studio with a C# windows application using entity framework/MySql database ? thanks

[@foxlearn]

OK. Thank you for your suggestion

[@deveshvagal3238]

If we create a SQL server database & connect it to the windows forms application & then copy the ".mdf" file from the SQL server & paste it in the project folder & use that .mdf file while creating the setup will it work ?

[@foxlearn]

Yes, it will work if you modify your connection string is attached database. and your client computer should install sql express or local database

[@surajjadhav2887]

After installing setup and running the app, I'm getting an error: Failed to update database because the database is read-only.

[@surajjadhav2887]

I found the solution: I had to manually give full control permission to the current user. But is there a way to avoid doing this manual work?

[@xbxb]

Failed to update database because the file is read only? How to fixed that?

[@kindred.spirit04]

it says that .mdf file is set to read-only, how can I solve this?

[@aleemosi]

Fox Learn, I have been following you for a while now. But, I have seen where people here are writing to you and the only thing is that you only reply to the positive content to you. Can you reply to those that I really asking for help? That would be greatly appreciated. Thank you.

[@Nighthawk11791]

i have a .dbo sql server database connected to my application no ( .md ) there will be a problem when a transfer the .exe programm to other computer?

[@foxlearn]

I think you should attach your database inside setup file

[@sonatteaa9818]

I canot insert any values....it shows read only database

[@feyyazaki1740]

thank you for video .. can we use Linq to Sql in project that we used sqllocaldb?

[@foxlearn]

OK, You can do that

[@feyyazaki1740]

@@foxlearn thank you.. can u suggest any video including how to do it ?

[@stalin2789]

In this way you can perform automatic updates?

[@foxlearn]

If you want you make your software automatically update you can use click once setup

[@mprincehanad]

Will this be working on client's pc without any sql installation or changing the connection string???

[@foxlearn]

Yes, you don't need change the connection string, sql server will be installed when installing the setup

[@dharmathedare]

@@foxlearn thanks , I like all videoes.

[@cybertree7571]

@@foxlearn i used SQLSERVER2019 . can i need to install SQLSERVER2019 on client machine??

[@zerosandones7547]

@@foxlearn will this work even if you didn't include sqlexpress on the prerequisites?

[@kamelsoltani3935]

@@foxlearn when i installed in my pc every thing work perfectly but when i installed in client pc i cant access to the local data base and show me error

[@hamdiayadi9815]

If the client wanted to access directly to the local database he open it from management studio ? And is there a way to access it online ?

[@foxlearn]

You should attach your database to sql server, then client can connect via lan or internet

[@hamdiayadi9815]

@@foxlearn you mean attach the database to sql server on the client's computer ?

[@axzuremc]

i cant find Setup project in my VS 2019 Community. Where can i download it?

[@foxlearn]

Open your Visual Studio, then Extensions=>Online=> Search Microsoft Visual Studio Installer Projects

[@axzuremc]

Fox Learn thanks!

[@cybertree7571]

when i opened service based Database from existing item it shows error... DB.MDF can't open beacause it's version 904 and This server support version 852 and earlier....Help me please

[@foxlearn]

i think you should create your database in old version, when creating the setup file you should add prerequires to new version or the same version of your sql database.

[@abdechafineji8782]

How can I do that with WPF application?

[@thoejan8820]

Hello I made this but I'm getting an error. setup project features net framework and select sql 2012 localdb. I get sqlcmdnutils.msi error when installing. what is solution ? thanks

[@thoejan8820]

please this is so important for me . please contact me .

[@foxlearn]

Can you post error details at c-sharpcode.com .Thank you !

[@kaushikdayalan924]

I tried this solution but every time I install I need to provide permissions for my mdf and ldf files for the user or else it doesn't allow me to write or update the database. Is there any possible fix ?

[@kaushikdayalan924]

@Gosai Rajendra I have tried everything but it wont be possible any other way. We need to create the database files in the tmp folder that is when you can have full access and control over it.

[@pratiksinhmakwana6986]

it is not working on the other pc when I try to install it. it shows the database error. it works only on the pc from which we have created. can you help me out with this? I want to run on to another pc.

[@foxlearn]

I think you should include sql server express when installing your app

[@pratiksinhmakwana6986]

@@foxlearn its still not working

[@abdechafineji8782]

How about SQL Server 2019? How can I create Setup.exe with Visual Studio 2019 and a Database created on SQL Server 2019 ( Sql server management studio )?

[@foxlearn]

Yes, you can do that

[@abdechafineji8782]

Fox Learn how???

[@cybertree7571]

@@foxlearn How??

[@ArunTr]

hi how to fix database read only error in service based database ? it is not working in my pc and pc cliendt

[@ArunTr]

@@esat986 hocam cevabiniz icin tesekkurler. Kurulu dizin ve alt dizinlere izin verdim sorun kalmadi.

[@shreyasj1596]

Please provide background music links as well in the description

[@foxlearn]

OK. Thank you for your suggestion !

[@randomgaming2278]

I don't know why, but I followed the steps and yet whenever I make some changes in my data, it says my database is real-only. I tried to look at my database properties but can't locate the "Read-only" so I downloaded SQL server management. I found out that whenever I install the app on my laptop it gets converted into "Read-Only" can you show what to do? or do I really have to use SQL server management to fix it all the time when it gets installed?

[@progalion4647]

Don't Install your project in Program Files Folder

[@NTKM-om9vn]

@@progalion4647 where should it be installed?

[@progalion4647]

@@NTKM-om9vn wow , it was 1 year ago , um I almost remember you have to install it anywhere else than Program Files

[@temirkhanamanbaev42]

The great channel about C#, thank you very much!!!

[@foxlearn]

Thank you so much !

[@haithamwehbi6552]

not working when i install it on other computer, it says problem with sql server, any idea how to fix this?

[@foxlearn]

You should tick sql server at prerequisite dialog box

[@haithamwehbi6552]

@@foxlearn the whole folder or just the tables?

[@bulentozben1603]

How to Create Setup.exe in Visual Studio 2019 with MySQL Database? please help thanks.

[@bojidarkamenski3432]

So nice video!!! Thank you! Have you ever tried to create setup exe with squirrel

[@foxlearn]

OK. Thank you for your suggestion.

[@cloud77hot40]

How can I create the setup file?

[@kamelsoltani3935]

Thank you for the video every thing clear and easy to understand i installed in my laptop and everything work perfectly but when I installed to client pc he cant access to database

[@nekdan]

Thanks man. I fixed the error!

[@jimuelmadlangsakay1870]

why is my visual studio 2019 don't have setup? anyone can help me..

[@mzansi_kleva]

Please can you do the same using a WIX toolset

[@foxlearn]

OK. Thank you for your suggestion !

[@mdziaulhaq2576]

Thank you sooooooooo much...... keep going on.

[@foxlearn]

Thank you !

[@hossienhassanhamow3489]

I did exactly what you did, but when I installed the app on another computer doesn't work!!! Could you tell me why? Please

[@foxlearn]

What error are you getting? Have you attach your database inside setup file?

[@hossienhassanhamow3489]

@@foxlearn thank you for replay My error is about database, because the form show and work, but without data. I think I didn't attach.

[@hossienhassanhamow3489]

@@foxlearn it works but my data that I have in database like customers name and address doesnt show. All deleted?!

[@ChrisTian-sd5yq]

@@hossienhassanhamow3489 maybe the database change to read only

[@hossienhassanhamow3489]

@@ChrisTian-sd5yq I don't know, I have to check it

[@issamtoufella4760]

Many thanks to you; the content is well explained. Thank you so much

[@foxlearn]

You're welcome. Thank you !

[@xfedelx]

how about Microsoft Access database?

[@foxlearn]

OK. I'll upload soon !

[@ahmadsaad8743]

How to fix database read only error in service based database ?

[@ABsazerNer]

Set it readable and writable to everyone in their properties

[@ahmadsaad8743]

If You mean database file property . So I do it but its not working my PC and virtual machine. Any other suggestions ?

[@ArunTr]

@@ahmadsaad8743 hi bro i have the same problem. How do you fixed it?

[@hasanaslan9840]

Çok Teşekkür Ederim Türkiyeden selamlar olsun sizlere

[@foxlearn]

Thank you

[@sinthi315]

how to create .exe file of windows form project with MySQL database in visual studio 2019?

[@foxlearn]

Thank you for your suggestion. I'll make tutorial soon

[@ashirafzal6771]

Thankyou soo much Fox Learn

[@foxlearn]

You're welcome. Thank you !

[@bidawialsaedi7533]

Thanks a lot ❤️👏

[@solutions4software]

That's a great explanation appreciated

[@foxlearn]

Thank you !

[@Hxlip09xStickman]

Thanks i will us am using this for my new video

[@KeijiJohnLibadisos]

cant open the app after installing

[@foxlearn]

What error are you getting?

[@ravindutharaka519]

Thank you ❤❤❤

[@sanjeevarora3735]

THERE IS AN ERROR " DATABASE IS READ ONLY"

[@porquereyna29]

Same error

[@petertharwat7352]

Really many thanks

[@foxlearn]

Thank you !

[@manjeetnandal1]

Many thanks!

[@foxlearn]

You're welcome. Thank you !

[@AyyashKLD]

thank you so much

[@foxlearn]

Thank you !

[@massmedialaser3399]

great!

[@alirezaabedi1885]

good job

[@foxlearn]

Thank you !

[@when_if_then_else]

ขอบคุณครับ

[@foxlearn]

Thank you !

[@jkeee1800]

Thank you very much

[@foxlearn]

Thank you !