Visual Studio SP1: EntityDataSource – Overview Screencast

12 במאי 2008

Visual Studio SP1: EntityDataSource - Overview Screencast I have just posted an overview screencast about EntityDataSource to channel9. The EntityDataSource is the new ASP.Net Data Source that ships as part of the ADO.Net Entity Framework in Service Pack 1 of Visual Studio 2008 and .Net Framework 3.5. In this video you will get a quick overview of the EntityDataSource and see some additional features you may want to explore later. If you want a step by step walkthrough of using the EntityDataSource, here is where you can find: Using the EntityDataSource...

Visual Studio 2008 SP1: ADO.Net Entity Framework support for FILESTREAM

Visual Studio 2008 SP1: ADO.Net Entity Framework support for FILESTREAM In Visual Studio 2008 and .Net Framework 3.5 SP1, not only that LINQ to SQL supports SQL Sever 2008 FILESTREAM, but also the ADO.Net Entity Framework supports FILESTREAM as well. Using the File Management Schema from my SQL Server 2008 FILESTREAM post, I created a simple .net application that uses Entity Framework in order to access the file contents. Just a reminder of how the Files table looks like: CREATE TABLE . (     FileID uniqueidentifier NOT NULL ROWGUIDCOL PRIMARY KEY,     FileContents varbinary(max) FILESTREAM DEFAULT(0x) ) and the corresponding Entity Data Model and generated...

Visual Studio 2008 SP1: EntityDataSource Where Clause

Visual Studio 2008 SP1: EntityDataSource Where Clause This post in one of a series of blog posts about SP1 of Visual Studio 2008 and .Net Framework 3.5. In the previous post about the EntityDataSource I've showed how to use it in a very basic way, which meant that I didn't customize the EntityDataSource at all. In this post I'll show how to filter the displayed entities by adding a where clause expressed by an Entity SQL statement. Taking from where I finished in the last post, I now want to filter the customers by their city, according to the city that...
no comments

Visual Studio 2008 SP1: EntityDataSource for ASP.Net

Visual Studio 2008 SP1: EntityDataSource for ASP.Net EntityDataSource is a new DataSource control for ASP.Net (just like ObjectDataSource and SQLDataSource and more recent - LinqDataSource) which makes declaratively binding ASP.NET UI controls to Entity Data Models very easy. In this post I will build a simple web application that uses EntityDataSource in order to demo how it is being used. 1. Create a simple Web Application, and create an initial GridView on it. <body>     <form id="form1" runat="server">     <h1>         Using the EntityDataSource</h1>     <asp:GridView runat="server" ID="GridView" />     </form> </body> 2. Create a new ADO.Net Entity Data Model. Add a new ADO.Net Entity Data Model item to...

Visual Studio 2008 SP1: Querying an ADO.Net Data Service via .Net Client

Visual Studio 2008 SP1: Querying an ADO.Net Data Service via .Net Client This post is a part of a series of posts Exploring Beta 1 of Visual Studio 2008 and .Net Framework 3.5, and specifically, the ADO.Net Data Services framework that will ship as part of it. In part1 I had a step by step guide for building a simple web data service, that exposed Entity Sets of the Entity Data Model I've created. Then, I used the browser to request data from the Data Service. Although it was very nice, it was not useful in real applications. In this post,...
no comments

Visual Studio 2008 SP1: A Simple ADO.Net Data Service Walkthrough

Visual Studio 2008 SP1: A Simple ADO.Net Data Service Walkthrough Back in December, when the last preview of ADO.Net Data Services was released I wrote several blog posts about the topic. Now that Beta 1 of Visual Studio 2008 and .Net Framework 3.5 Service Pack 1 is out, it is a good time to refresh those posts. Additionally, this post is a part of a series of posts Exploring Beta 1 of Visual Studio 2008 and .Net Framework 3.5. This post is a step by step guide for building a Simple ADO.Net Data Service for the Blog database I have been...
no comments

Visual Studio 2008 SP1: SqlFileStream – Managed API for SQL Server 2008 FILESTREAM

Visual Studio 2008 SP1: SqlFileStream - Managed API for SQL Server 2008 FILESTREAM In the previous post about SQL 2008 FILESTREAM I created a sample database and added a text file using sql commands. In this post I will build a simple .net client application that adds a file to the database and than reads it. To do that, I will go over a code block that I've written and explain it. You can download the full source code project for this post. Some related posts about SQL Server 2008: SQL Server 2008 FILESTREAM - Part 1 SqlFileStream - Managed API for...
no comments

Visual Studio 2008 SP1: Sync Services for ADO.Net with SQL Server 2008 Change Tracking

Visual Studio 2008 SP1: Sync Services for ADO.Net with SQL Server 2008 Change Tracking One of the main pillars of Visual Studio 2008 and .Net Framework 3.5 Service Pack 1 if the better integration with SQL Server 2008. Service Pack 1 now uses the Change Tracking capabilities of SQL Server 2008 in order to identify the incremental changes. During the process of writing this post, I am building a simple application with both Visual Studio 2008 and Visual Studio 2008 + SP1 in order to spot the changes in Sync Services for ADO.Net in SP1. The first thing you notice when you...

Visual Studio 2008 SP1: LINQ to SQL and FILESTREAM

Visual Studio 2008 SP1: LINQ to SQL and FILESTREAM In Visual Studio 2008 and .Net Framework 3.5 SP1, not only that LINQ to SQL supports the new date and time types of SQL Server 2008, but is also supports forking with FILESTREAMs. Using the File Management Schema from my SQL Server 2008 FILESTREAM post, I created a simple .net application that uses LINQ to SQL in order to access the file contents. Just a reminder of how the Files table looks like: CREATE TABLE . (     FileID uniqueidentifier NOT NULL ROWGUIDCOL PRIMARY KEY,     FileContents varbinary(max) FILESTREAM DEFAULT(0x) ) and the corresponding LINQ to SQL...
no comments

Visual Studio 2008 SP1: LINQ to SQL with SQL Server 2008 Date Time Types

Visual Studio 2008 SP1: LINQ to SQL with SQL Server 2008 Date Time Types One of the pillars of Visual Studio 2008 and .Net Framework 3.5 Service Pack 1 is the support for SQL Server 2008 in Visual Studio 2008 tools and the related data access technologies. I decided to check out how LINQ to SQL works with SQL Server 2008 Date and Time types in Visual Studio 2008 and .Net Framework 3.5 Beta. I created a simple database with a single table called friends, that holds my friends names and birth dates in several formats according the existing and new...
no comments