Click here to Skip to main content
12,398,000 members (45,074 online)
Click here to Skip to main content
Articles » Database » Database » ADO.NET » Downloads

Stats

34.6K views
709 downloads
32 bookmarked
Posted

Transaction Isolation in ADO.NET Entity Framework

, 15 May 2011 CPOL
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)

Share

About the Author

Dr. Song Li
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.

You may also be interested in...

| Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.160721.1 | Last Updated 15 May 2011
Article Copyright 2011 by Dr. Song Li
Everything else Copyright © CodeProject, 1999-2016
Layout: fixed | fluid