Entity Framework Context Lifetime Best Practices (blogs.microsoft.co.il)

submitted by gilf(1458) 3 days, 2 hours ago

In this post I’m going to write about one of the major decisions that you need to take when you use ORM tools like Entity Framework. This decision is the context lifetime. read more...

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

tags: ADO.NET Database another

Using Unit of Work Pattern with Entity Framework (blogs.microsoft.co.il)

submitted by gilf(1458) 4 days, 20 hours ago

In a previous post I explained how to create a simple repository on top of Entity Framework. In this post I’ll explain the Unit of Work pattern and how we can use it with our data access layer. read more...

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

tags: ADO.NET Database another

SharePoint Custom Columns That May Come Handy To You! (www.sharepointboost.com)

submitted by TechShouter(25) 5 days, 6 hours ago

SharePoint tools related Custom Columns are playing useful roles in SharePoint. In this page there are several tools that may be come handy some day. read more...

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

tags: ADO.NET Database another

Nice wrapper around ADO.Net to call sprocs. (dayly-programming.blogspot.com)

submitted by valera.kolupaev(10) 6 days, 1 hour ago

Nice wrapper around ADO.Net to call stored procedures. The key benefit is descriptive consumer code. Wrapper supports error handling and output parameters. read more...

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

tags: ADO.NET Database another

Connection pooling myth explained (www.revenmerchantservices.com)

submitted by satalaj(95) 9 days ago

Here, I have explained the how connection pooling works. and myth about connection. read more...

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

tags: ADO.NET Database another

Performance Tuning – ADO.NET to Oracle (blogs.datadirect.com)

submitted by MikeNelson(15) 11 days, 12 hours ago

Performance tuning and tuning options available for Progress DataDirect's ADO.NET provider for Oracle. read more...

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

tags: ADO.NET Database another

Playing with C# Func and ADO.NET (derans.blogspot.com)

submitted by derans(94) 15 days, 5 hours ago

I’ve always liked the look of the generic Func and I think the possibilities behind it are awesome. However, it’s usually difficult for me to find a good place to use it. So anyhow, I was playing with the good ole ExecuteScalar & ExecuteNonQuery commands on the IDbCommand interface and came up with something kinda cool. At least I thought so… read more...

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

tags: ADO.NET Database another

Agile ADO.Net Persistence Layer Part 4: Writing data access for new da (rlacovara.blogspot.com)

submitted by rlacovara(60) 15 days, 17 hours ago

I recently decided that I needed to take a fresh look at how to build a persistence architecture that would provide the flexibility of an ORM, that would embrace change instead of resist it (making maintenance code easier), and would use ADO.Net. I started building from the ground up, threw away any best practices that resulted in friction, and Agile ADO.Net Persistence Layer is the result. Part 1 in the series can be found here: Agile ADO.Net Persistence Layer Overview. read more...

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

tags: ADO.NET Database another

Table Per Concrete Type Inheritance in Entity Framework (blogs.microsoft.co.il)

submitted by gilf(1458) 16 days, 4 hours ago

The last inheritance mapping that I’m going to write about is the Table Per Concrete Type inheritance (TPC). This inheritance type is very rare but you should be aware of how to create it when it is needed. You can read about TPT and TPH from here and from here. read more...

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

tags: ADO.NET Database another

Table Per Hierarchy Inheritance in Entity Framework (blogs.microsoft.co.il)

submitted by gilf(1458) 17 days, 1 hour ago

In the second inheritance mappings tutorials I’m going to write about the Table Per Hierarchy (TPH) inheritance mapping. If you want to read about the first mapping I showed go to the Table Per Type post from here. read more...

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

tags: ADO.NET Database another

Table Per Type Inheritance in Entity Framework (blogs.microsoft.co.il)

published 13 days, 19 hours ago, submitted by gilf(1458) 19 days ago

The first inheritance mapping I’m going to show is called Table Per Type or TPT. Before I start with the example lets define what is TPT. read more...

1 comment | category: ADO.NET | Views: 164

tags: ADO.NET Database another

Using Repository Pattern with Entity Framework (blogs.microsoft.co.il)

submitted by gilf(1458) 20 days, 22 hours ago

One of the tools for reaching for persistence ignorance is to build a facade between the data access layer and your business logic. Such facade will prevent the knowledge of how the data access is working and with which technology. That abstraction can be achieved by using the Repository Pattern. In the post I’ll show how you can use the Repository Pattern. read more...

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

tags: ADO.NET Database another

Agile ADO.Net Persistence Layer: Part 3 Service Class SingleDTO Data A (rlacovara.blogspot.com)

submitted by rlacovara(60) 21 days, 16 hours ago

This BAL design embraces change. It’s written with the attitude that we know change is going to happen so we’re going to give you as few things as possible to modify, and make sure we don’t have any cross cutting dependencies, so that you can make changes easily. read more...

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

tags: ADO.NET Database another

A Guide to implementing NHibernate with MySql (www.makecodingeasy.com)

submitted by stevevaubell(65) 29 days ago

NHibernate is a way of managing information from an application to a relational database. It is part of Hibernate.Core developed for the .Net platform. The way NHibernate works is by mapping the database to the objects with the use of XML files. read more...

1 comment | category: ADO.NET | Views: 6

tags: ADO.NET Database another

Defining Custom Functions in Entity Framework (blogs.microsoft.co.il)

submitted by gilf(1458) 1 month, 8 days ago

During the SDP conference I have been asked about the use of functions inside the EDM. This post will try to answer one such question of how to define a custom function in EF. read more...

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

tags: ADO.NET Database another

Functions to Convert IP Addresses to 8 byte Long Values and Back (www.stardeveloper.com)

submitted by Faisal_Khan(110) 1 month, 13 days ago

This tutorial describes methods to convert an IP address to an 8 bytes long value, and back, both in C# and T-SQL. Will use methods like ConvertIPToLong() and ConvertLongToIP() to do the job. We will also learn why storing IP addresses as long values is more efficient to store and use. read more...

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

tags: ADO.NET Database another