I’ve begun working with ASP.NET MVC which is why I came upon this thread, so I’m not sure if you you’re still checking for improvements. I don’t like the idea of adding the new property to a partial class on the entity framework because it doesn’t allow for as much change. Try labeling your Deparment … Read more
The Entity Framework doesn’t require new data providers, exactly. Rather, it requires Entity Framework providers which extend existing data providers, to provide additional services required by the Entity Framework, such as complex SQL generation, which are not part of the existing ADO.NET data model. I don’t think that there’s anything stopping anyone from writing an … Read more
[Update] Because L2E is used you need to save all the linked objects first before you can save the main object. Which makes sense otherwise you would create (in my example) an artist without it’s contact object. This isn’t allowed by the database design. [/Update] Here’s my implementation which worked. [AcceptVerbs(HttpVerbs.Post)] public ActionResult Create([Bind(Exclude = … Read more
You can read about connection pooling here. Basically, as long as the connection string is the same (including case), connections will be taken from the same connection pool.
First, I would review my SQL 2000 code and get to the bottom of why this deadlock is happening. Fixing this may be hiding a bigger problem (Eg. missing index or bad query). Second I would review my architecture to confirm the deadlocking statement really needs to be called that frequently (Does select count(*) from … Read more
When you create your context, you can set a connection string. To build this connection string, you can parse the connection string without the password with an EntityConnectionStringBuilder and then parse the inner connection string with an other ConnectionStringBuilder, depending on your browser. Then you can set the password and pass it to the constructor. … Read more
Check out Introduction to ADO.NET Tutorial ADO.NET Tutorial Lesson 1 An introduction to ADO.NET I’m sure there’s plenty more out there – just google for “ADO.NET” and “Tutorial” …… UPDATE: If you want to connect to your local SQL Server Express, and connect to the “Northwind” database, and read the top 5 customers from the … Read more
IMO, not at the moment. It is clear (from recent announcements especially) that EF is in for some heavy revisions as the “thunderdome” scenario plays out between LINQ-to-SQL and EF. Whatever happens, EF (in a few years) will almost certainly look quite different to EF today. Or certainly “different enough” ;-p As such, my view … Read more
You should not be doing this in the Entity Framework. All popular relational databases support ON CASCADE DELETE on foreign keys which is a lot more efficient as well. I suggest you just go with that.
Microsoft offers .NET 3.5 Enhancements Training Kit it contains documentation and sample code for ADO.NET EF