Blog Easyciel for .NET

In the first episode, I tried to install SQL Server 2008 RC0 Advanced Express (with only the database engine and Management Studio)...but the result was "Error 1814" during service starting. First action : "Repair"...but not possible because the program can only repair a well performed installation. In this second episode, I tried to uninstall the database engine service that previously failed and then try to reinstall it !!!   Uninstalling... ... [More]

Developer Tools, Sql Developer Tools, Sql

Previously installed : - .NET Framework 3.5 - Windows Installer 4.5 Tested prerequisites : Installation dashboards : Planning       Requirements details on Microsoft site : http://msdn.microsoft.com/en-us/library/ms143506(SQL.100).aspx Stand alone installation steps of the SQL Server 2008 Advanced Express Licensing   Installing setup support files   Defining features et settings ... [More]

Developer Tools, Sql Developer Tools, Sql

SQL Server Management Studio Express is a limited version that authorize access to SQL Server Databases (Express or not). Analysis, Reporting, Integration Services or SQL Server Agent are not available from this Express version. Most important features from  "Databases" and "Security" trees are available to create and modify databases and security accounts (but not roles). The following features are also available: - Generate scripts - Attach/... [More]

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

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 .NET Projects, DAL, Developer Tools, doc, Learning, Sql

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 .NET Projects, DAL, Developer Tools, doc, Learning, Sql

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 .NET Projects, Developer Tools, DAL, Sql

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 Developer Tools, DAL, Sql

“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 DAL, Sql

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 DAL, Sql