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

submitted by wladek(38) 7 days, 5 hours 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: 256

tags: Framework Entity Database another

Painless database logging with mongoDB(www.jefclaes.be)

submitted by JefClaes(650) 8 days, 4 hours ago

While browsing the source code of the ELMAH mongoDB provider, I learned about a special type of collections: capped collections. Logging to the database can be extremely useful, but also rather expensive. Using this feature, you can turn on database logging without too many worries. read more...

add a comment |category: Database |Views: 4

tags: Database another

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

submitted by dpeterson(4397) 12 days, 5 hours 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

Code !t: Choosing the cloud for your database(www.etabakov.com)

submitted by etabakov(10) 14 days, 2 hours ago

You will find some tips and advices on how to choose your cloud provider for storing the database read more...

add a comment |category: Database |Views: 12

tags: cloud Azure rds Database SQL another

Linq to Asp.net controls(ianswerable.com)

submitted by govindmalviya(14) 15 days, 4 hours ago

Query on controls of page through linq read more...

add a comment |category: ADO.NET |Views: 8

tags: ADO.NET Database another

Custom Paging using: EntityFramework 4.1, ObjectDataSource, and ListVi(www.keivansadra.com)

submitted by techiemae(64) 17 days, 2 hours ago

What is custom paging? Say if you have a 1,000 records inside of a database, and you want to display 10 records at a time. Conventional paging would require you to fetch all and have your website or web application handle the paging. As we all know, this can get pretty expensive with the records travelling from the database to your website or web application. read more...

add a comment |category: ADO.NET |Views: 5

tags: ADO.NET Database another

Database-first development pattern using Entity Framework 4.1 and SQL (www.keivansadra.com)

submitted by techiemae(64) 19 days, 17 hours ago

Modern-day development is becoming increasingly easy. In this article, we will walk you through creating a data-driven website by using some of the newest tools provided by Microsoft ®. You will see just how easy this can be. We will be creating a three tier application that will display a list of users using Microsoft's new ListView control. read more...

add a comment |category: ADO.NET |Views: 19

tags: ADO.NET Database another

Persisting Enumeration Classes with nHibernate(lostechies.com)

submitted by dpeterson(4397) 27 days, 5 hours 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

Copy Table Data And Schema From One DataBase To Another In SQL Server(www.csharpaspnetarticles.com)

submitted by amit.jain(1186) 1 month, 4 days ago

Several Times We need to Copy Table Schema And Data From One DataBase to Another In Sql ServerWe can do it in following ways. read more...

add a comment |category: Database |Views: 6

tags: Database another

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

submitted by BlackWasp(4217) 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(2314) 1 month, 10 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

Execute TSQL statement with ExecuteStoreQuery in entity framework 4.0(www.dotnetjalps.com)

submitted by jalpesh(1352) 1 month, 21 days ago

I was playing with entity framework in recent days and I was searching something that how we can execute TSQL statement in entity framework. And I have found one great way to do that with entity framework ‘ExecuteStoreQuery’ method. It’s executes a TSQL statement against data source given enity framework context and returns strongly typed result. read more...

add a comment |category: ADO.NET |Views: 15

tags: ADO.NET Database another

Attached failed, Unable to open physical file, operating system error (www.sqltrends.blogspot.com)

submitted by sagitariusmzi(123) 1 month, 25 days ago

Whenever user try to attache the database files, he might get this error Attached failed, Unable to open physical file, operating system error read more...

add a comment |category: Database |Views: 4

tags: Database another

Bulk Insert in .NET applications, part 1(wp.me)

submitted by ruijarimba(81) 2 months, 2 days ago

This is the first of a 2 series articles about how to perform bulk inserts in your .NET applications, using a SQL Server database. In this article I’ll show how to create a wrapper object for SqlBulkCopy that can do a bulk insert for a collection of objects. In the second article I’ll show how that wrapper can be easily integrated with Entity Framework (creating extension methods for DbContext and ObjectContext). read more...

add a comment |category: ADO.NET |Views: 6

tags: ADO.NET Database another