ORM Mapper for .NET

1. November 2009
As I'am working on NHibernate and discovering some specific behaviour that increase the complexity of the tool...I just wanted to have a look on the different tools that can cover the same type of features in the .NET world.First, I just want to creat a first list and then take the time to compare the most important features to report a benchmark.So the most known and powerful tool is basically supposed to be NHIBERNATE if we are considering that is it an OPEN SOURCE tool !A well apprec... [More]

.NET Projects, DAL ,

Using "Dynamic Data" with Entity Data model instead of Linq To Sql model

6. July 2008
Previous versions of "Dynamic Data" were designed to use "LinqToSql". With this service pack beta, you can use it with "Entity Data". The "Context" type that must be declared is now "ObjectContext" instead of "Datacontext". After having installed... - .NET Framework 3.5 SP1 Beta - Visual Studio 2008 SP1 Beta (can be download here for .NET and here for VS) ...you can create a new project "Dynamic D... [More]

.NET Projects, Asp.net, DAL, Developer Tools , , ,

Installing ADO Entity Framework Beta3 on Visual Studio 2008

18. February 2008
Install this VS 2008 update : KB945282. Download it here Install ADO.NET Entity Framework Beta 3. Download it here Install ADO.Net Entity Framework Tools Dec 07 Community Technology Preview. Download it here Watch "ADO.NET Entity Designer Video - CTP 2" video here

.NET Projects, DAL, Developer Tools, doc, Learning, Sql , , , , ,

Installing Web Services Software Factory on Visual Studio2008

18. February 2008
Install "GuidanceAutomationExtensions -  July 2007 CTP". Download it here (this version can be attached to VS 2005 or 2008 Orcas) Install "Software Factory - Modeling Edition Feb 2008 CTP". Download it here (this version is attached to VS 2008) Apply this fix to avoid the following error "Project Creation Failed" from Visual Studio 2008 while creating a new project. This is due to some assembly redirects that are added to the devenv.exe.config fil... [More]

.NET Projects, DAL, Developer Tools, doc, Learning, Sql , , , , ,

Le requêtage universel

31. August 2006
Avec la nouvelle mouture de C# version 3 (ou VB.NET version 9), Microsoft annonçait il y a déjà quelques mois la venue de LINQ ! Pour rappel, LINQ est un langage orienté requêtes qui autorise notamment de procéder à des requêtes, non plus seulement sur des bases de données, mais également sur des structures XML ou encore des entités métiers. Ces différentes cibles sont appelées des « ... [More]

.NET Projects, Developer Tools, DAL, Sql , , ,

Oracle et .NET et plus encore !

17. August 2006
Pour les utilisateurs de Oracle sous .NET 2.0, une nouvelle version du provider Oracle est sortie récemment. Cette dernière se veut plus performante que celles proposées par Microsoft : System.Data.OracleClient, OLEDB for Oracle et bien évidemment ODBC…pour les 2 derniers, pas trop de doutes. Quand au 1er provider présent dans le namespace "System.Data.OracleClient" je vais prochainement procéder à quelques tests com... [More]

Developer Tools, DAL, Sql , ,

Sql server 2005 Service pack 1

23. April 2006
“Microsoft announces the availability of SQL Server 2005 Service Pack 1 (SP1) with Database Mirroring, SQL Server Management Studio Express, additional options for ISVs and normal feature fixes.” Get more news and download from the url : http://www.microsoft.com/sql/sp1.mspx

DAL, Sql ,

Get age from date of birth in Transact Sql

12. December 2005
Calculate the age of a person from his date of birth. Parameters : @dateNaissance = Date of birth @dateActuelle = Current date (from GetDate()) CREATE FUNCTION [dbo].[fnGetAge] (@dateNaissance SMALLDATETIME, @dateActuelle SMALLDATETIME) RETURNS INT AS BEGIN DECLARE @age INT SET @age = FLOOR(DateDiff(dd,@dateNaissance,@dateActuelle)/365.25) IF (Day(@dateNaissance) = Day(@dateActuelle)) AND (Month(@dateNaissance) = Month(@dateActuelle))    BEGIN     &... [More]

DAL, Sql ,