DotNetSlackers Latest ASP.NET News in Category ADO.NET

Calling UDFs from Entity Framework - Not what you might have expected

Julia Lerman Blog - Dont Be Iffy... — Sat, 29 Nov 2008 00:00:00 GMT

Along with Stored Procedures, you can bring UDFs into an EF Entity Data Model which also surfaces as a function in SSDL. Unlike Stored Procedures, however, a UDF is composable on the server side and this is reflected in its attributes. Function Name="ufnLBtoKG" ReturnType="nvarchar" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="true" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo"> Parameter Name="Pounds" Type="int" Mode="In" /> Function>.csharpcode, .csharpcode...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

ASP EasyForm: ASP.NET-like forms in two minutes

The Code Project Latest Articles — Thu, 27 Nov 2008 00:00:00 GMT

EasyForm allows you to create ASP.NET-like forms, with state keeping and server side event handling...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Presented By:

Thu, 27 Nov 2008 00:00:00 GMT

The Battle Against Lawless Database Design

Simple Talk — Tue, 25 Nov 2008 00:00:00 GMT

In which Tony becomes fascinated by the sessions he attended at the recent PASS conference called "Much Ado: A Panel discussion about Nothing". After becoming amazed by the passion and energy that a bunch of database guys could put into a debate about "don't know" (null), and its many nuances, he daydreams about the potential for a pressure group: the Battle Against Lawless Database Design (or project BALDY)...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Silverlight and Data Communications

Rick Strahls WebLog — Fri, 21 Nov 2008 00:00:00 GMT

So Im finally getting an opportunity to work with Silverlight in a real application. I had mentioned this application in the past a few weeks back the original application architecture was created as a Flash front end to a .NET backend which provides service style XML data. In the original app the server infrastructure was used purely to serve data to the client basically a complex, mostly meta data drive SQL Engine based on complex stored procedures feed the client Xml data. Originally our data...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

PDC Essentials @ Buenos Aires

eXtensible mind — Wed, 19 Nov 2008 00:00:00 GMT

On Tuesday 18th, Victor and I will be presenting A Lap Around VS2010. Check which other talks are available and register here. This is the event information: Horario: martes, 18 de noviembre de 2008 16:00 - 22:00 p.m. Lugar: ITTC. Sarmiento 1113 Piso 5. Buenos Aires Argentina. Registraci??n Descripci??n: Durante los d??as del 27 al 30 de Octubre se lleva a cabo la Professional Developer Conference en Los Angeles, Estados Unidos. Durante este evento Microsoft realiza grandes anuncios sobre novedades...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Presented By:

Wed, 19 Nov 2008 00:00:00 GMT

Visual Basic en Espaa (Lisa Feigenbaum)

The Visual Basic Team — Mon, 17 Nov 2008 00:00:00 GMT

This week Jonathan Aneja and I are traveling from city to city, and presenting to VB.Net user groups in Spain. We began the tour in Barcelona where we were speaking at TechEd EMEA, and will finish in Madrid. VB MVP Pep Lluis Blano organized the entire itinerary! Here are the topics for the presentations: IDE: 2005, 2008, 2010 Language: LINQ, VB XML, VB 9, VB 10 VB6: Interop Forms Toolkit The schedule is below. Each meeting is 3hrs. Come join us if you can! Monday 11/17/2008, 9:30am: Barcelona,...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Summary of the MSDN Freedom Roadshow

Jason N. Gaylords Blog — Mon, 17 Nov 2008 00:00:00 GMT

For those not at the MSDN Freedom Roadshow in Scranton, PA today, you are missed a good show. Heres what happened:

David Solivan David presented a talk called UI, UX, U confused? The purpose was to show the various options we have and to explain when one option may be better than another by stepping through the design process. Theres a URL he had mentioned during his talk that will show your best options. Check it out at http://tinyurl.com/59vk7b.
Lindsay Rutter started off by talking about the PDC 08. She mentioned that all should come out and attend the MSDN Conference in New York City. The best part is that PDC was between $2000 and $3000 per developer. The MSDN conference is $99. Furthmore, Lindsay plugged our user group, .NET Valley. If you are not a member, join today! Also, register for the MSDN Flash newsletter. Its a great way to get the latest news on events, news, and more.
Lindsay then decided to build an ADO.NET Entity Framework based on Davids proof of concept app he spoke about earlier.
Dani Diaz followed up Lindsay by showing how to use a WCF/REST solution for connecting to the Entity Framework and serving up the data. He also showed how to use MVC, jQuery, and Json during his talk. Dani recommended following Rob Bagbys and Dan Rigsby for more information about WCF/REST.
Lindsay came after Dani and talked about how XAML and WPF works for developers and designers. She also showed off the final product including the UI/UX decisions, EF stuff, WCF, and WPF that we saw throughout the day.
Finally, Dani wrapped up the day by talking about IE8 development.

Great work team! I hope the MSDN team visits Scranton more often!

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Presented By:

Mon, 17 Nov 2008 00:00:00 GMT

PDC Essentials @ Buenos Aires

eXtensible mind — Mon, 17 Nov 2008 00:00:00 GMT

On Tuesday 18th, Victor and I will be presenting A Lap Around VS2010. Check which other talks are available and register here. This is the event information: Horario: martes, 18 de noviembre de 2008 16:00 - 22:00 p.m. Lugar: ITTC. Sarmiento 1113 Piso 5. Buenos Aires Argentina. Registracin Descripcin: Durante los das del 27 al 30 de Octubre se lleva a cabo la Professional Developer Conference en Los Angeles, Estados Unidos. Durante este evento Microsoft realiza grandes anuncios sobre novedades...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Using the WCF OAuth channel with an ADO.NET service

Pablo M. Cibraro (aka Cibrax) — Fri, 14 Nov 2008 00:00:00 GMT

As I promised in my previous post "OAuth Channel for WCF RESTful services", it is now time to show this new channel in action with a real service. To make this sample more interesting, I decided to base this implementation on an ADO.NET service that provides information about contacts. This post will be a kind of walk-through to demonstrate all the steps required to implement the ADO.NET service, and then, the final integration with OAuth. 1.Create a custom data source (IQueryable) implementation...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Doing CRUD Operations in Silverlight 2 Against ADO.NET Data Services

WebLog of Ken Cox [MVP] — Thu, 13 Nov 2008 00:00:00 GMT

Many of us have been struggling to create business-oriented (LOB) forms using Silverlight 2 and ADO.NET Data Services. There are plenty of community samples on reading data, but a dearth of real-world content on creating and updating records. The Silverlight...(read more)...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

ASP.NET Data Binding

The Code Project Latest Articles — Wed, 12 Nov 2008 00:00:00 GMT

A beginner's introduction to data binding that includes: Simple (ie. fields) Data Binding, Complex (list and datagrid), and database access using ADO.NET...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Entity Framework and Read Stored Procedures - a new perspective

Julia Lerman Blog - Dont Be Iffy... — Wed, 12 Nov 2008 00:00:00 GMT

A few years ago at DevConnections I had a long talk with Gert Drapers (from the SQL Server team) about EF when it was still in an early beta. I'm now at DevConnections in Las Vegas and caught up with Gert again and had an interesting follow up conversation about EF now that it is released. I really like getting the perspective of folks who bring a different expertise to the table. We talked a lot about stored procs especially the DBA perspective. The EF designer currently [handily] supports...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Presented By:

Wed, 12 Nov 2008 00:00:00 GMT

CSS Compatibility updated

QuirksBlog — Tue, 11 Nov 2008 00:00:00 GMT

I’ve updated the CSS Compatibility Table as the first step in a complete update of all Tables. Frankly, this was one of the more boring updates I’ve ever done.I tested four browsers: IE8-as-IE7 (in backward compatibility mode, in other words). There are no differences with a regular IE7. Opera 9.62; no differences with 9.51 Chrome 0.3; no differences with Safari 3.1, except that it does not support text-shadow Firefox 3.1b. Fortunately I found a few differences there: contrary to Firefox 3.0 it supports...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Presented By:

Tue, 11 Nov 2008 00:00:00 GMT

We made it to OpenForce

DotNetNuke Developer - DotNetNuke Core Team Member and Excellent Programmer — Tue, 11 Nov 2008 00:00:00 GMT

So we made the trek to Las Vegas today, the long grueling trek it is. We even adopted a kid today (more like a father ;), Scott Spradlin joined the Engage team on our flight and cab ride to the hotel! Its late, almost midnight here and I have a presentation...(read more)...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Announcing ShadowCamp

.Avery Blog — Tue, 11 Nov 2008 00:00:00 GMT

There are more and more one-day local events every year, and each time people come into town, go to the event, then meander home sometime on Sunday. A couple months ago I had the idea to run a separate unaffiliated event on the Sunday morning after one of these local events. We will be having the first ShadowCamp this weekend on Sunday after the Raleigh Code Camp. It will be held at the same venue (ECPI) and will of course be free. The only catch is that we are capping attendance at 30, but it...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Presented By:

Tue, 11 Nov 2008 00:00:00 GMT

DevDinnerOnDemand: Overview of the .NET Framework 3.5 SP1

Federal Developer Weblog — Mon, 10 Nov 2008 00:00:00 GMT

With the .NET Framework 3.5 (the version native to Visual Studio 2008) coming up on its first anniversary, Microsoft is poised to release the first update to the framework in the form of Service Pack (SP1). This Service Pack is unlike your standard Service Pack, in that it will introduce new features/capabilities to the .NET Framework. Some of these features where originally planned to be in the initial release of the framework and others are features/capabilities added to enhance...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

TreeView in a ComboBox dropdown using RadControls for Silverlight

the telerik blogs — Sat, 08 Nov 2008 00:00:00 GMT

As far as I can tell from the experience of my colleagues with RadControls for ASP.NET AJAX, one of the common feature requests for RadComboBox and RadTreeView is combining them into one piece. Recently we started to receive similar requests for RadComboBox and RadTreeView for Silverlight. Placing a TreeView in a ComboBox sometimes makes a lot of sense, so I decided to research the best way to do it.

The first, the simplest and most obvious way is to place a RadTreeView as content of RadComboBox:

<input:RadComboBox>
<nav:RadTreeView 
ItemTemplate="{StaticResource ItemTemplate}" 
ItemsSource="{StaticResource ItemsSource}" />
</input:RadComboBox>

However, it has one important limitation: RadComboBox cannot display the RadTreeView selected item. The problem is that RadTreeView is actually inside a RadComboBoxItem and RadComboBox displays only the content of its items. I think that you could create a special ContentPresenter that will display the SelectedItem property of the inner TreeView, but in addition, you should search for ways to avoid other UI glitches, such as RadComboBoxItem highlight around the whole TreeView.

I abandoned this approach and created completely different prototype, that follows a WPF article I found on the Internet several months ago (I am unable to find it again, so if you know it, post a comment here with a link and I will give credit to the author). The idea is to replace the RadComboBox ItemsPresenter with a RadTreeView. To do this, I copied the two RadComboBox control templates into a separate XAML file, effectively creating a new RadComboBox skin (this is something that I will describe in detail in another article). You can see how it worksin the attached source. To keep this article short, I removed most of the code, leaving only the elements that demonstrate the idea:

<!-- NonEditableComboBoxTemplate -->
<ControlTemplate x:Key="NonEditableComboBox" TargetType="input:RadComboBox">
<Grid Name="MainGrid">
<ToggleButton x:Name="DropDownButton" />
<ContentPresenter />
<Popup x:Name="PART_Popup">
<ScrollViewer x:Name="PART_ScrollViewer">
<nav:RadTreeView ItemsSource="{TemplateBinding ItemsSource}"
ItemTemplate="{TemplateBinding ItemTemplate}"
ItemTemplateSelector="{TemplateBinding ItemTemplateSelector}"
ItemContainerStyle="{TemplateBinding ItemContainerStyle}"
ItemContainerStyleSelector="{TemplateBinding ItemContainerStyleSelector}"
SelectedValuePath="{TemplateBinding SelectedValuePath}"
system:ScrollViewer.HorizontalScrollBarVisibility="Disabled"
system:ScrollViewer.VerticalScrollBarVisibility="Disabled" />
</ScrollViewer>
</Popup>
<Rectangle x:Name="DisabledVisual" />
</Grid>
</ControlTemplate>

I bound all data related properties of the RadTreeView with the corresponding properties of RadComboBox. I also disabled the integrated scrollbars of RadTreeView. The only thing left is to synchronize RadComboBox.SelectedItem and RadTreeView.SelectedItem. To do that I created a simple class, containing one attached property:

using Telerik.Windows;
public class ComboBoxExtensions
{
public static bool GetEnableInnerTreeView(DependencyObject obj)
{
return (bool)obj.GetValue(EnableInnerTreeViewProperty);
}

public static void SetEnableInnerTreeView(DependencyObject obj, bool value)
{
obj.SetValue(EnableInnerTreeViewProperty, value);
}

public static readonly DependencyProperty EnableInnerTreeViewProperty =
DependencyProperty.RegisterAttached("EnableInnerTreeView", typeof(bool), typeof(ComboBoxExtensions),
new System.Windows.PropertyMetadata(InitializeTreeView));

private static void InitializeTreeView(DependencyObject d,
DependencyPropertyChangedEventArgs args)
{
RadComboBox combo = d as RadComboBox;
if (combo != null)
{
combo.AddHandler(RadTreeView.SelectionChangedEvent, 
new Telerik.Windows.Controls.SelectionChangedEventHandler(
delegate(object sender, Telerik.Windows.Controls.SelectionChangedEventArgs e)
{
RadTreeView tree = e.OriginalSource as RadTreeView;
if (tree != null)
{
combo.SelectedItem = tree.SelectedItem;
combo.IsDropDownOpen = false;
}
}));
}
}
}

When you set the attached property on RadComboBox, ComboBoxExtensions attaches a RoutedEvent handlerto the RadTreeView's SelectionChanged event. The handler synchronizes the TreeView and the ComboBox, and closes the ComboBox dropdown when you change the selection in the treeview. The following code demonstrates the RadComboBox declaration:

<input:RadComboBox 
telerik:RadControl.Theme="{StaticResource TreeInCombo}"
SelectedValuePath="Text"
ItemsSource="{StaticResource ItemsSource}"
ItemTemplate="{StaticResource ItemTemplate}"
local:ComboBoxExtensions.EnableInnerTreeView="True" />

For completeness, here is the hierarchical ItemTemplate, applied on RadComboBox:

<DataTemplate x:Key="SubItem">
<TextBlock Text="{Binding Text}" />
</DataTemplate>

<telerik:HierarchicalDataTemplate x:Key="ItemTemplate" 
ItemsSource="{Binding Children}"
ItemTemplate="{StaticResource SubItem}">
<TextBlock Text="{Binding Text}" />
</telerik:HierarchicalDataTemplate>

You may ask "Why not bind the SelectedItem properties of the two controls?". The answer is - RadTreeView's SelectedItem property is read-only and Silverlight does not provide the needed instruments (Triggers) to bind a read-only property. "Why SelectedItem is read-only?" you may ask - the answer is "Because RadTreeView is hierarchical control".

Here is the source:

TreeInCombo

I hope this article helps. Let me know if you have questions, you know how to find me :)

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Chapters 2-9 are on RoughCuts, here`s the full chapter list

Julia Lerman Blog - Dont Be Iffy... — Fri, 07 Nov 2008 00:00:00 GMT

While the entire book is now in production, so far Chapters 2-9 have made it into the RoughCuts version. Here's a full chapter list. THere are still "working titles" on a few of the chapters. 1. Introducing ADO.NET Entity Framework 2. EDM Basics 3. Foundations of Querying 4. More Querying (yes, this is a working title!) 5. Basics of Stored Procedures in the EDM 6. A More Practical Model 7. Databinding Entity Framework in Windows Apps 8. Object Services 9. Customizing...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Presented By:

Fri, 07 Nov 2008 00:00:00 GMT

The Hitchhiker`s Guide to Entity Framework

Julia Lerman Blog - Dont Be Iffy... — Tue, 04 Nov 2008 00:00:00 GMT

In the original version of Douglas Adams famed book, "42" was the answer to everything. Actually it was a typo. What he meant was "V2". ...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Article published at dotnetslackers.com

Patrik Löwendahls shout — Sat, 01 Nov 2008 00:00:00 GMT

I just an article published over at dotnetslackers.com. Check it out: http://dotnetslackers.com/articles/ado_net/Modeling-domains-with-The-Entity-Data-Model.aspx Trackback link: http://www.lowendahl.net/trackback.aspx?id=234 ...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.