http://forums.asp.net/t/1807342.aspx/1?entity+framework+vs+enterprise+libraryFri, 25 May 2012 08:06:07 -040018073424996797http://forums.asp.net/p/1807342/4996797.aspx/1?entity+framework+vs+enterprise+library <p>Hi all:</p> <p>I am working on asp.net project. client has given me access to a database remotely. database has two users. One user has read only access where as other one has owner access. Client says for read data purposes use the first one and for insertion etc use the second one. Also, client told me to use stored procedures as much as possible because there is lot of data that will be coming from db server. I want to use Entity framework(edmx). Can I use stored procedures with it? Before Entity framework, I have been using Enterprise library for stored procedures. Do I need to go back and use it with stored procedures so that all database related work is done on db server end instead of bringing data to web server using entity framework ? Also, how can I use one user for read only purposes and other user to access same db for insertion? Do I need to create two web configs ? Does it make difference to make a user read only and get results faster ?</p> <p>If there is better approach then please suggest me.</p> <p>Please suggest.</p> 2012-05-25T06:19:42-04:004996952http://forums.asp.net/p/1807342/4996952.aspx/1?Re+entity+framework+vs+enterprise+library <p>This is a tuturial I wanted to go over since I had the same question as you a while back.</p> <p><a href="http://msdn.microsoft.com/en-us/data/gg699321">http://msdn.microsoft.com/en-us/data/gg699321</a></p> <p>However, I ended up using Enterprise Library (so easy to work with sprocs!) and created my own mappers, which basically just was static methods that take in a dataset (from Ent.Lib) and manually map it to an instance of a domain model.</p> 2012-05-25T08:06:07-04:00