Browse by Tags

• ADO.NET Data Services
• Community
• DevCenter
• Entity Framework
• LINQ
• N-tier
• OBA
• Office
• SharePoint
• SQL Server
• VS2005
• VS2008
• WCF
• Winforms
• WPF
• XML

Inserting Master-Detail Data into a SQL-Server Compact Edition Database
15 September 09 07:11 PM

Yesterday John posted on the Visual Studio Data blog how to Refresh the Primary Key Identity Column during an Insert Operation using SQL Server. In that post he shows how the DataSet designer sets up a batch Insert statement to retrieve identity keys Read More...

Postedby Beth Massi | 4 Comments    

Filed under: Visual Basic, VS2008, SQL Server, DevCenter, Article, Data

Filtering Child DataTables Using TableAdapters
22 July 09 05:02 PM

Since my last post on filtering child collections using Entity Framework , I have had more than a few emails about how to load filtered child DataTables that are part of a master-detail relationship and then get them to save properly through the TableAdapters. Read More...

Postedby Beth Massi | 2 Comments    

Filed under: Visual Basic, VS2008, DevCenter, Article, Data

Master-Detail Data Binding in WPF with Entity Framework
14 July 09 04:24 PM

Today I thought I would talk about a really common scenario in data applications, creating a master-details (one-to-many) data entry form. I’ve written about WPF data binding and Entity Framework a lot in the past: Posts: Master-Details with Entity Framework Read More...

Postedby Beth Massi | 16 Comments    

Filed under: Visual Basic, WPF, DevCenter, Article, Data, Entity Framework

Using TableAdapters to Insert Related Data into an MS Access Database
14 May 09 05:48 PM

I’ve posted before about how to use TableAdapters to update parent-child (master-detail) relationships against SQL server. It’s pretty straightforward and Visual Studio generates all the code for you to properly insert, update and delete your data. However Read More...

Postedby Beth Massi | 45 Comments    

Filed under: Visual Basic, VS2008, Winforms, DevCenter, Article, Data

Using the WPF ObservableCollection with EF Entities
08 May 09 03:29 PM

The ObservableCollection is a special WPF collection that provides proper notifications to the UI when items are added, removed, or the list is refreshed because it implements INotifyCollectionChanged . It’s common to use this collection (or inherit from Read More...

Postedby Beth Massi | 12 Comments    

Filed under: Visual Basic, WPF, LINQ, VS2008, DevCenter, Article, Data, Entity Framework

Notifying the UI when Entity References Change in Lookup Comboboxes
04 May 09 07:51 PM

Last week I wrote about how to data bind WPF lookup comboboxes to entities returned from the Entity Framework. I described that the key to this type of binding is setting the SelectedItem to the object reference itself on the navigation property instead Read More...

Postedby Beth Massi | 6 Comments    

Filed under: Visual Basic, WPF, VS2008, DevCenter, Article, Data, Entity Framework

Data Binding WPF Lookup Combobox Values to EF Entities
30 April 09 07:57 AM

It’s extremely common to have to hook up lookup tables on your data entry forms in order to populate foreign keys in a database. I’ve talked about how to do this in Winforms and WPF with Datasets and LINQ to SQL before: How Do I: Create a Lookup Combobox Read More...

Postedby Beth Massi | 8 Comments    

Filed under: Visual Basic, WPF, LINQ, VS2008, DevCenter, Article, Data, Entity Framework

Tally Rows in a DataSet that Match a Condition
27 April 09 07:24 PM

Today I got a question that comes up often in data application programming about how to count rows in a DataSet that matched a condition. The DataSet may be bound to a DataGridView or other list control and it’s tempting to start looking at the control Read More...

Postedby Beth Massi | 8 Comments    

Filed under: Visual Basic, LINQ, Winforms, DevCenter, Article, Data

OBA Part 3 - Storing and Reading Data in Word Documents
12 February 09 05:55 PM

In my last few posts we've been building a simple Office Business Application (OBA) for the new Northwind Traders. If you missed them: OBA Part 1 - Exposing Line-of-Business Data OBA Part 2 - Building and Outlook Client against LOB Data In this post I'm Read More...

Postedby Beth Massi | 6 Comments    

Filed under: Visual Basic, VS2008, DevCenter, Article, XML, Office, Data, ADO.NET Data Services, SharePoint, OBA

ADO.NET Data Services - Intercepting Queries and Adding Validation
21 January 09 08:53 PM

Last few posts I've been building a WPF client against ADO.NET Data Services, if you missed them: Using ADO.NET Data Services ADO.NET Data Services - Building a WPF Client ADO.NET Data Services - Enforcing FK Associations and a Fix for Deleting Entities Read More...

Postedby Beth Massi | 7 Comments    

Filed under: Visual Basic, WPF, LINQ, DevCenter, Article, Data, N-tier, Entity Framework, ADO.NET Data Services

ADO.NET Data Services - Building a WPF Client
15 January 09 08:30 PM

In my last post I introduced ADO.NET Data Services and how you can easily expose your data model via RESTful services that support the basic CRUD (Create,Retrieve,Update,Delete) operations. Basic CRUD database operations map well to the familiar HTTP Read More...

Postedby Beth Massi | 11 Comments    

Filed under: Visual Basic, WPF, VS2008, DevCenter, Article, Data, N-tier, ADO.NET Data Services

Using ADO.NET Data Services
09 January 09 07:52 PM

This week I worked through a good article on getting started with ADO.NET Data Services (a.k.a Astoria) called Using ADO.NET Data Services . If you're not familiar with the technology it's basically a framework for exposing your data models via RESTful Read More...

Postedby Beth Massi | 33 Comments    

Filed under: Visual Basic, DevCenter, Article, Data, Entity Framework, ADO.NET Data Services

Community Article: Scaling ADO.NET DataTables
17 December 08 12:43 PM

We just released a new community article onto the Visual Basic Developer Center by one of our MVPs, Jeff Certain , called Scaling ADO.NET DataTables . In this article Jeff shows shows us how to query and aggregate data using the built in DataTable methods Read More...

Postedby Beth Massi | 1 Comments    

Filed under: Visual Basic, LINQ, Community, Article, Data

Formatting Data in WPF Controls
12 December 08 04:32 PM

One of the basic things that we need to do as business application developers is to make sure that data being displayed to a user makes sense to them and that they know what type of data something is when they are making edits. In every business application Read More...

Postedby Beth Massi | 19 Comments    

Filed under: Visual Basic, WPF, DevCenter, Article, Data

Master-Details with Entity Framework Explicit Load
10 December 08 04:45 PM

Unlike LINQ to SQL, in Visual Studio 2008 Service Pack 1 explicit loading is the default behavior in the Entity Framework. When a query is executed within the Entity Framework, the entities returned by the query are fully accessible, but any associated Read More...

Postedby Beth Massi | 21 Comments    

Filed under: Visual Basic, DevCenter, Article, Data, Entity Framework