Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 117
  • Last Modified:

Could you explain in what aspects adding the database inside App_Data folder is a better aproach that maintain it under SQL Manager Studio ?

Hi Experts

Could you explain in what aspects adding the database inside App_Data folder is a better aproach that maintain it under SQL Manager Studio ?
Accordingly with my researches the database must be detatched from SQL Manager Studio to be added to the solution, isn't it?

If the database is added to App_Data folder an EDMX file must be created ?  

Thanks in advance
1
Eduardo Fuerte
Asked:
Eduardo Fuerte
1 Solution
 
David Johnson, CD, MVPOwnerCommented:
if in appdata then your application has to attach and detach the database
0
 
Prakash SamariyaIT ProfessionalCommented:
Could you explain in what aspects adding the database inside App_Data folder is a better aproach that maintain it under SQL Manager Studio ?
  • The App_Data folder has permissions set on it that will allow the Web page to read and write data to the database file. The folder also supports special syntax to enable using the DataDirectory relative path in connection strings.
  • It works with SQL Server Express (however it has some limitation), SQL Express is free, no costing for database.
  • App_Data folder is restricted folder by IIS, so user won't be able to get things from it, so it is safe.
  • You must need to open and close connection after using it in code; or you can use connection pooling to reduce live connections capacity.
  • It is not good if you are creating giant application which contains millions of data and have huge active connections!

If the database is added to App_Data folder an EDMX file must be created ?  
  • EDMX (Entity Data Model in XML format) is Entity Framework container, to get the complete database information easily to the developer. So if you would to access database easily, EF will allows you to do that!

Hope this will clear your doubts!
0
 
Eduardo FuerteAuthor Commented:
Thank you, Prakash

It's clearer.
I'm going to deep in this subject and then rerturn with new questions.
1

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now