ADO.NET

Another screencast in the SQL Server Everywhere series demonstrating the deployment options for SQL Server Everywhere.  In this screencast I talk about the Admin, Central, MSI deployment model with the assistance of ClickOnce bootstrappers as well as the private deployment model. More info…

In this screen cast I demonstrates the new Sync Designer for caching data locally in SQL Server Compact Edition.  This is part 1 showing the basics.  In part 2 I'll demonstrate how to split the code from client to server using WCF to synchronize data across internet protocols. For more…

How to configure your Entity to perform Insert/Update/Delete against user defined Stored Procedure. Stay tuned, Wriju (http://blogs.msdn.com/b/wriju)

In part 1, I used the Visual Studio Orcas Sync Designer to configure and synchronize 3 lookup tables to be cached locally in SQL Server Compact Edition using the Sync Services for ADO.NET CTP. In part 2, I take the cached lookup tables and split up the client and server sync components using…

The ADO.NET Data Services Framework (a.k.a. Project "Astoria") introduced a way of creating and consuming flexible, data-centric REST services. By combining data services with the Microsoft Sync Framework, learn how to create offline-capable applications that have a local replica of…

Unai Zorrilla, Development Team Lead de Plainconcepts, nos introduce ADO.NET Data Services en una serie de videos. En este primer video, nos enseña como crear el servicio. Recursos:    - En Microsoft  http://msdn.microsoft.com/en-us/data/bb931106.aspx …

The Entity Framework supports both select and action stored procedures.  We covered action stored procedures in a previous screencast.  In this screencast, Rob Bagby will illustrate how to import select stored procedures.  However, the entity framework goes beyond simply importing…

The Entity Framework provides the ability to model rich conceptual layers that meet the needs of our applications.  One such model is table-per-type inheritance.  In this model, each entity is mapped to a distinct table in the store.  Each table contains all of the properties…

The Entity Framework provides the ability to model rich conceptual layers that meet the needs of our applications.  One such model is table-per-hierarchy inheritance.  In this model, the data for a hierarchy are stored in one table.  This table has a discriminator column that…

For some applications, time to market is simply critical. If your application is heavily-data driven and backed by a well-designed database schema, you could help yourself a lot be looking at the dynamic duo of ASP.NET Dynamic Data and the ADO.NET Entity Framework. Together, these two technologies…