Click here to Skip to main content
15,892,537 members
Articles / Programming Languages / C#

Transaction Isolation in ADO.NET Entity Framework

Rate me:
Please Sign up or sign in to vote.
4.62/5 (8 votes)
15 May 2011CPOL15 min read 54.1K   799   32  
This article presents an example on how to control the transaction isolation level in ADO.NET Entity Framework.
<Window x:Class="EFTransactionExample.MainWindow"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        FontFamily="Calibri"
        Title="MainWindow" Height="350" Width="525">
    
    <Grid Margin="10">
        <Grid.RowDefinitions>
            <RowDefinition Height="auto" />
            <RowDefinition Height="auto" />
            <RowDefinition Height="*" />
            <RowDefinition Height="auto" />
        </Grid.RowDefinitions>
        
        <TextBlock Text="Entity Framework Transaction Isolation Level Experiment"
                   Margin="10, 0, 0, 10"
                   FontSize="16" FontWeight="SemiBold" Foreground="Brown" />
        <Grid Grid.Row="1">
            <Grid.ColumnDefinitions>
                <ColumnDefinition Width="*" />
                <ColumnDefinition Width="*" />
                <ColumnDefinition Width="*" />
            </Grid.ColumnDefinitions>

            <Button Grid.Column="0" Content="Re-set Salary"
                    Margin="10,0,5,0"
                    Command="{Binding ResetSalaryCommand}" />
            <Button Grid.Column="1" Content="Raise Salary"
                    Margin="5,0,5,0" 
                    Command="{Binding RaisetSalaryNonSerializedCommand}" />
            <Button Grid.Column="2" Content="Raise Salary Serialized"
                    Command="{Binding RaisetSalarySerializedCommand}"
                    Margin="5,0,10,0"/>
        </Grid>
        
        <Border Grid.Row="2" BorderThickness="1" BorderBrush="Blue"
                CornerRadius="5" Margin="5">
            <DataGrid ItemsSource="{Binding EmployeeInformation}"
                  IsReadOnly="True" AutoGenerateColumns="False" Margin="10">
                <DataGrid.Columns>
                    <DataGridTextColumn Header="ID" Width="50"
                                    Binding="{Binding ID}" />
                    <DataGridTextColumn Header="Name" Width="300"
                                    Binding="{Binding Name}" />
                    <DataGridTextColumn Header="Salary" Binding="{Binding Salary}" />
                </DataGrid.Columns>
            </DataGrid>
        </Border>

        <TextBlock Grid.Row="3" Text="{Binding StatusInformation}"
                   Margin="10, 0, 0, 0" />
    </Grid>
</Window>

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
United States United States
I have been working in the IT industry for some time. It is still exciting and I am still learning. I am a happy and honest person, and I want to be your friend.

Comments and Discussions