When you try to connect to a SQL Server database from a client application, under certain circumstances, you might get the below error message: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Named Pipes Provider, error: 0 – No process is on…
Entity Framework: Code First
A few days ago we had our second user group meeting for 2016 at Cyprus .NET User Group and it was all about data access. I was the speaker at the event and I presented Entity Framework and more specifically the “Code First” development approach. Entity Framework is an Object/Relational…
Data Access and Consumption with WCF Data Services and PowerPivot
It’s been a while since my last post but I’ve changed job a few weeks ago and I was in the process of adapting to the new environment 🙂 OK! It is time to sit back, relax a bit, have a cold beer, put some music on, and start writing!…
MY-TG SQL Server Community Series – Session Review (Sync Framework)
On September 19, 2009, I delivered a session with topic the Microsoft Sync Framework, during the Mysore SQL Server Community Series. The exact topic was: “Flexible data synchronization with Microsoft Sync Framework”. Further below I provide a short review for my session and I also provide the PowerPoint presentation along…
24 Hours of PASS – Session Review (18 – ADO .NET Data Services)
On September 2, 2009, I had the pleasure to deliver a session on ADO .NET Data Services, during that great SQL Server Marathon; 24 Hours of PASS! This great event was a series of 24 non-stop live, free webcasts dedicated to pure SQL Server knowledge. The exact topic of my…
Mysore PASS Chapter SQL Server Webcasts Series
Newsflash: More free SQL Server training is on the way! The Mysore/Mandya Technology Group (MY-TG) organizes a series of SQL Server Webcasts which started on Saturday, September 12th, 2009 and will be taking place every Saturday for the next few weeks. To this end, every Saturday, two sessions are presented.…
Accessing SQL Azure Using ADO.NET
In my first post on SQL Azure (SQL Azure: A First Contact) I talked about how you can access SQL Azure using SQL Server 2008 Management Studio (SSMS). In this post, the journey continues with “walking” on the cloud using ADO .NET 🙂 Here’s the recipe! Ingredients A valid SQL…
24 Hours of PASS!
I got asked to present a one-hour SQL Server development session during the “24 Hours of PASS” event which starts on September 2, 2009, 00:00 GMT. The “24 Hours of PASS” is a series of live one-hour webcasts broadcast over a 24 hour period that focus on various SQL Server…
ADO .NET Data Services for the Web / Visual Studio 2010: A First Look
Another Cyprus .NET User Group special event took place a few days ago (June 18th, 2009). This event was somehow “celebratory”. It was the last offline event before summer holidays. The next offline event (within the series of Community Nights) will take place after two months time, in September 2009.…
Upcoming CDNUG Event, June 18th – ADO .NET Data Services for the Web / Visual Studio 2010: A First Look
It is time for another CDNUG event! This event will probably be the last event of CDNUG before summer holidays. The next event will take place next September. To this end, the CDNUG committee decided that this event should feature a variety of .NET and SQL Server Technologies thus providing…
Screencast: Using Inheritance in the ADO .NET Entity Framework
Welcome to another screencast dedicated to SQL Server 2008 Programmability! This screencast again features the ADO .NET Entity Framework. The screencast demonstrates how the developer can create an entity data model in Visual Studio 2008, and goes one step further, thus demonstrating a simple way of using inheritance in the…
Screencast: How to Create an Entity Data Model
Welcome to my first screencast dedicate to SQL Server 2008 Programmability! This screencast features the ADO .NET Entity Framework; a new feature of Microsoft .NET Framework 3.5 providing the developer with fast, robust and scalable data access. SQL Server 2008 fully supports the ADO .NET Entity Framework, allowing developers to…
The Entity Framework – Part 2 – Inheritance
As promised on my previous Entity Framework-related post I will try through a series of posts which will contain examples, to talk about the ADO. NET Entity Framework and all the cool features it provides the developer with. This post discusses about one of those features; Inheritance. Inheritance allows creating…
The Entity Framework – Part 1 – Introduction
This is the first (or maybe the second) of a series of posts dedicated to the ADO .NET Entity Framework. The purpose of these posts is to try to provide the necessary knowledge on what exactly is the Entity Framework, how can be used and how can help for an…
The ADO .NET Entity Framework
During the development cycle of a database application, the developer may face issues having to do with the fact that the logical (relational) and related infrastructure may not match the application’s needs. This happens as relational schemas are often normalized in such a way, for being able to be shared…