EF 4.1+ POCO, Repository and Specification Pattern Framework(huyrua.wordpress.com)

submitted by wladek(38) 7 days, 1 hour ago

I've been playing around with Code First EF implementations for awhile now and by far the best implementation I've seen is a framework by Huy Rua. It has the following functionality baked in: True Separation of Concerns for entities (no need for a data annotations dependency). A Generic Repository. This should do the trick for 80% of your standard CRUD operations without the need for repo's per entity. Supports multiple DbContext's and builds them dynamically. And finally a straightforward Specification pattern implementation. I use it as a base data layer for all my projects. read more...

1 comment |category: Database |Views: 254

tags: Framework Entity Database another

EF5 Release Candidate Now Available(blogs.msdn.com)

submitted by dpeterson(4397) 12 days, 1 hour ago

The release candidate for Entity Framework 5.0 is now available on Codeplex. There have been several new improvements since beta 2. read more...

4 comments |category: Database |Views: 277

tags: Database another

Persisting Enumeration Classes with nHibernate(lostechies.com)

submitted by dpeterson(4397) 27 days, 1 hour ago

Jimmy Bogard shares an example of persisting enumeration classes to the database, and reading them back out with the correct representation. read more...

add a comment |category: Database |Views: 88

tags: Database another

Tackling timeouts(softscenario.blogspot.com)

submitted by snaits(197) 1 month, 3 days ago

A brief how-to of how to cope with SQL timeouts. read more...

1 comment |category: Database |Views: 128

tags: ADO.NET Database another

SQL Server Transaction Savepoints(www.blackwasp.co.uk)

submitted by BlackWasp(4212) 1 month, 6 days ago

Sometimes Transact-SQL (T-SQL) scripts require the ability to roll back some parts of a transaction whilst allowing other elements of a process to be committed to the database normally. This can be achieved with the use of transaction savepoints. read more...

2 comments |category: Database |Views: 46

tags: Database another

Which ORM tool is the Best for .NET?(blog.pluralsight.com)

submitted by jnpetrov(95) 1 month, 8 days ago

Check out the results from Pluralsight's poll asking their users which is the best best Object-relational mapping tool for .NET. read more...

1 comment |category: Database |Views: 794

tags: Database another

Open DBDiff for SQL Server 2008(www.ginktage.com)

submitted by isenthil(2309) 1 month, 9 days ago

Last few weeks , i have been playing around with this cool tool called Open DBDiff . As the name suggests Open DBDiff read more...

1 comment |category: Database |Views: 152

tags: Database another

Good Devs Don't Like Magic(tatiyants.com)

submitted by atatiyan(127) 3 months, 7 days ago

Solutions of the “magical” variety go out of their way to hide (obfuscate?) the underlying implementation. They present the developer with a Faustian bargain: I’ll make it easy for you to get things done so long as you don’t question how I work. read more...

1 comment |category: Database |Views: 184

tags: Database another

EF 4.3 Code-Based Migrations(blogs.msdn.com)

submitted by dpeterson(4397) 3 months, 18 days ago

Entity Framework 4.3 has been released, and the big new feature is migrations for code-first projects. This article is a walkthrough of how to take advantage of the new migration support. read more...

1 comment |category: Database |Views: 286

tags: Database another

Basic Raven DB Indexing and Querying with Lucene(unstructuredthinking.blogspot.com.au)

submitted by guffshemr(178) 3 months, 20 days ago

We've got up and running with Raven DB for our new project, which has been a delight to use from a code perspective, but one of the big gaps for me is figuring out how to do SQL like queries. I'm not too bad at putting a SQL query together as something I do semi-regularly as part of my job, so I thought it shouldn't be too much of a stretch to start pulling some statistics. I was wrong. read more...

add a comment |category: Database |Views: 123

tags: Database another

Why is RAID So Important for Databases?(www.sqlservercurry.com)

submitted by flyingkick(331) 3 months, 21 days ago

A good server design has no, or very few, single points of failure. One of the most common server component that fails, are disks. So data redundancy becomes essential to recoverability. Redundant Array of Independent/Inexpensive Disks (RAID) is a disk system that provides better fault-tolerance by making use of redundancy of disk(s). read more...

1 comment |category: Database |Views: 175

tags: Database another

Redis 2.4.6 has been released(data.story.lu)

submitted by pardogo(80) 4 months, 15 days ago

Redis 2.4.6 has been release,it fixes a critical replication bug and adds a minor feature read more...

add a comment |category: Database |Views: 31

tags: Database another

Telerik OpenAccess ORM Q3 2011 – Connection pool types(blogs.telerik.com)

submitted by vaskess(120) 4 months, 15 days ago

With the Q3 2011 release of Telerik OpenAccess ORM we introduced three connection pool type settings. The OpenAccess Connection Pool, OpenAccess Connection Pool with OpenAccess Connection Management and the ADO Connection Pool. This blog post will show how these types can be used and when it makes sense to make use of them. read more...

add a comment |category: Database |Views: 58

tags: Database another

NoSQL MongoDb Enterprise Design with C# .NET, the Repository Pattern(www.primaryobjects.com)

submitted by surfer6(362) 4 months, 18 days ago

Learn how to use a NoSQL MongoDb database to create a simple .NET application for displaying Dragons. Our architecture will utilize the repository pattern, combined with a global database context provider. We'll create a 3-tier system for accessing the Dragons, creating, updating, and deleting. read more...

1 comment |category: Database |Views: 308

tags: Database another

NHibernate: Collections of components - an alternative(notherdev.blogspot.com)

submitted by notherdev(238) 4 months, 28 days ago

When we have a model where an entity has some properties collections used for displaying it to the customer and we are not querying our data by these properties at all, it may seem right to map these collections in NHibernate as collections of components. Component in NHibernate is an object without its own identity, being a part of its parent entity. Our collections sounds similiar in terms of lifetime and ownership, but different in terms of relationship - these are one-to-many. In complex scenarios, additional queries became a serious issue. We've decided to try another solution - it's so simple that it can't go wrong. read more...

13 comments |category: Database |Views: 151

tags: Database another

Performance Tips: Speed up Data Access(visualstudiomagazine.com)

submitted by pwhe23(972) 5 months, 12 days ago

Faster performance in business applications comes down to reducing the "critical two" -- disk I/O and trips to the server. Doing that means doing a lot of things right, starting with your database design -- and tweaking your ADO.NET code helps, too. read more...

1 comment |category: Database |Views: 260

tags: Database another