fix database file problem

garyepaul · July 29th, 2010, 11:00 AM

I had not seen your reply earlier today before my post. I hope to see scripts posted very soon. Your book is loaded with great ideas and I'm frustrated that I've been unable to access them as your book intended. Thanks for gettting to this.

nlecren · August 9th, 2010, 11:10 AM

I should have an update today regarding the fix for this. I worked on creating both DB scripts for all chapters as well as new .mdf files built using SQL Express 2008 for those of you who do not have the R2 version.

I will keep everyone posted

shogi · August 10th, 2010, 03:34 PM

I also had problems with SQL Express 2008 at the beginning. The only thing I had to do was to set the option "User Instance" to False. After that I was able to connec to the file.

punkouter · August 10th, 2010, 04:23 PM

I get 4004 errors randomly as well.. anyone get these ?

I converted the 2008 r2 db to a 2008 by creating a script to run on 2008 db

shogi · August 11th, 2010, 02:19 PM

I've scripted alll Tables and Views and populated an Access-DB.
You can download it at:
http://www.steffsworld.ch/WROX/Fitness.zip

I didn't try those scripts and DB for other SQL Versions but hopefully you can create a SQL Database and populate the Tables with the values from the Access-file

nlecren · August 11th, 2010, 02:43 PM

The new DB files and scripts have been made available from the book's download page. These have all been tested against SQL Server Express 2008.

Please let me know if you have any additional problems working with these files!

Nick

shogi · August 12th, 2010, 01:31 AM

Your files work also for SQL Server 2005. The only thing you have to change by creating the Files (mdf/ldf) is to set the minimum size to 3MB

MerrillMarie · August 17th, 2010, 05:46 PM

Are you going to update the PDF version of your book as well?

Have a stupid question, all on timing. I need data out of a data context when the page loads .. without any user intervention.
Current process is to load data from data context then items source it to a data grid. Next step is to do a for each in the data context and creat an ienumerable. Every thing works fine, but only if I do a button click after the data grid has been item sourced. Is there some way i can do this without user intervention?

Would really appreciate any suggestions!

rlcraven · August 18th, 2010, 02:02 PM

Hi MerrillMarie,

You can create a class that loads your data and fires an event when everything is loaded. In your page, create an instance of your class, call your load method, and also add a handler for the load completed event. In your handler you can bind/enable the grid.

Code:

    Public Sub Load()

        Dim oLoaderList As List(Of LoadOperation) = New List(Of LoadOperation)

        oLoaderList.Add(Context.Load(Context.Table1Query(vars), AddressOf OnTable1Loaded, oLoaderList))
         oLoaderList.Add(Context.Load(Context.Table2Query(vars), AddressOf OnTable2Loaded, oLoaderList))

    End Sub

Each "OnLoaded" procedure calls this procedure which will fire the event when everything is done.

Code:

    Private Sub UpdateLoadStatus(ByVal oOp As LoadOperation)

        Try
            Dim oLoaderList As List(Of LoadOperation) = oOp.UserState
            oLoaderList.Remove(oOp)
            If oLoaderList.Count = 0 Then
                RaiseEvent DataIsLoaded()
            End If

        Catch ex As Exception

        End Try

    End Sub

In your page loaded event, call your data loader class method

Code:

    Private Sub MyPage_Loaded(ByVal sender As Object, ByVal e As System.Windows.RoutedEventArgs) Handles Me.Loaded


        oDataLoader = New cDataLoader
        oDataLoader.Load()


    End Sub

Bind and enable your grid when the event fires

Code:

    Private Sub DataLoadComplete() Handles oDataLoader.LoadComplete

'--- handle grid here

    End Sub

Hope this helps,

Randy

MerrillMarie · August 18th, 2010, 02:42 PM

Thanks, Randy .. Really appreciate it !!!

I am a c# type, so I have asked a good Visual Basic friend who also has some c# experience to take a look at it

if you are bidexterous could i get a c# version?

when I get something to work I will post the code using one of the AdventureWorks tables and RIA services (linq to SQL)..

I think this will eventually help a lot of folks out there ..

Thanks again

Frank (Merrill Marie)