Use of SQL express ??

25 Oct 2006 11:18 AM

serge calderara

Dear all,

I have a big application which is based on different EXE files made with VB5
accessing data from an access database.
Now we plan to move those application under .NET annd SQL express 2005
instead of access.

The quetsions are :

-Would you rather go to store prodedure for collecting data or updating
data or dynamic querries inside code ?

- How to handle in the proper way the fact that different application can
access the same data while other application is still updating them ? what is
the corrct way to handle such case ?

Thanks for comments
regards
serge

25 Oct 2006 2:00 PM

W.G. Ryan [MVP]

"serge calderara" <sergecalder***@discussions.microsoft.com> wrote in
message news:266937DA-F446-412D-A882-C64D3ADA89F6@microsoft.com...
> Dear all,
>
> I have a big application which is based on different EXE files made with
> VB5
> accessing data from an access database.
> Now we plan to move those application under .NET annd SQL express 2005
> instead of access.
>
> The quetsions are :
>
> -Would you rather go to store prodedure for collecting data or updating
> data or dynamic querries inside code ?

--Don't start religious wars ;-) There's a case both ways and people get
passionate about it. I'd google around b/c I think the answer depends a lot
on your perspsective.

>
> - How to handle in the proper way the fact that different application can
> access the same data while other application is still updating them ?

That's a complex issue and really depends. Probably the most traditional
approach is to trap for DBConcurrencyException and let the user decide what
to do.
what is
Show quote

> the corrct way to handle such case ?
>
> Thanks for comments
> regards
> serge

25 Oct 2006 9:30 PM

William (Bill) Vaughn

I discuss this (complex) issue at length in my book. There are many factors
involved but generally most (by far) developers eventually migrate to SPs .

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
Between now and Nov. 6th 2006 you can sign up for a substantial discount.
Look for the "Early Bird" discount checkbox on the registration form...
-----------------------------------------------------------------------------------------------------------------------

Show quote

"serge calderara" <sergecalder***@discussions.microsoft.com> wrote in
message news:266937DA-F446-412D-A882-C64D3ADA89F6@microsoft.com...
> Dear all,
>
> I have a big application which is based on different EXE files made with
> VB5
> accessing data from an access database.
> Now we plan to move those application under .NET annd SQL express 2005
> instead of access.
>
> The quetsions are :
>
> -Would you rather go to store prodedure for collecting data or updating
> data or dynamic querries inside code ?
>
> - How to handle in the proper way the fact that different application can
> access the same data while other application is still updating them ? what
> is
> the corrct way to handle such case ?
>
> Thanks for comments
> regards
> serge

26 Oct 2006 1:58 PM

Cowboy (Gregory A. Beamer)

Show quote

"serge calderara" <sergecalder***@discussions.microsoft.com> wrote in
message news:266937DA-F446-412D-A882-C64D3ADA89F6@microsoft.com...
> Dear all,
>
> I have a big application which is based on different EXE files made with
> VB5
> accessing data from an access database.
> Now we plan to move those application under .NET annd SQL express 2005
> instead of access.
>
> The quetsions are :
>
> -Would you rather go to store prodedure for collecting data or updating
> data or dynamic querries inside code ?

Depends.

If you parameterize the queries correctly, you may find it a superior
position to sprocs, as there are conditions where sprocs have to recompile.
I would generally aim for sprocs over dynamic, however, but that is an
ingrained preference. There are advantages to both.

> - How to handle in the proper way the fact that different application can
> access the same data while other application is still updating them ? what
> is
> the corrct way to handle such case ?

Unless you cannot work under the optimistic locking and concurrency checking
mode, I would aim for that direction. Attempt to upate. If fails, show user
and allow him to make decision.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com

*************************************************
Think outside of the box!
*************************************************