Solved

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

Posted on 2016-07-28
3
66 Views
1 Endorsement
Last Modified: 2016-07-29
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
Comment
Question by:Eduardo Fuerte
3 Comments
 
LVL 78

Expert Comment

by:David Johnson, CD, MVP
ID: 41734220
if in appdata then your application has to attach and detach the database
0
 
LVL 8

Accepted Solution

by:
Prakash Samariya earned 500 total points
ID: 41734284
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
 

Author Closing Comment

by:Eduardo Fuerte
ID: 41735079
Thank you, Prakash

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

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now