What is the main difference in creating internal database in Visual Studio and external in sql server???

Hi there,

Not sure what you're asking. Where did you see these terms?

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

If I understand your question correctly the difference is dependent on what the application will be used for.

For a web app you would generally want to use an external database versus a local database stored in the websites directory. This is both for performance, data management and security reasons.

The exception would be if this was a desktop application and you needed to store data locally. Then it would make sense to use a local database stored in the install directory of the application.

Of course this is just my opinion and there may be other reasons I have not considered.

Hi,There
If you have external sql database then other website can access to it( if have enough permission). But You must choice database name so that there is no database by this name. If you use asp.net membership and roles You also must customize database object's.
If you have internal sql database then you can choice any name but another application cannot access it. How ever you don't need to customize database for users profile's , membership and so on.
I hope it help you

__________________
Please excuse me for poor and bad English.