Re: Creating a new Access database file (.mdb) in .NET/C#
- From: "William Vaughn" <billvaNoSPAM@xxxxxxxxx>
- Date: Sat, 3 Nov 2007 11:37:12 -0700
Frnak,
You definitely need to download my Ebook. No, SQLCe does NOT require periodic maintenance like JET. It can be passed around as a file like JET and backed up in a similar fashion (unlike JET). It's ideal for single user applications. Consider that this database is also fully encryptable--a feature not in JET or in SQL Server until 2008. It supports a full SQL syntax, a subset of the datatypes and a simpler, low-impact approach to data access.
Feel free to contact me directly if you have more questions. Clearly, there is some confusion about it in the newsgroups.
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
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)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------
"Frnak McKenney" <frnak@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:13inmn0hdcqds37@xxxxxxxxxxxxxxxxxxxxx
Bill,
Thanks for replying. I had planned to get back to you earlier, but,
well, ...
On Mon, 29 Oct 2007 10:11:42 -0700, William Vaughn <billvaNoSPAM@xxxxxxxxx> wrote:
I would also consider using SQL Server Compact edition for this
task. It's far easier to use permits you to create databases with a
single line of code. No, this is not another "SQL Server" binary
but an evolution of SQLCe and SQL Mobile that's been ported and
expanded to work on the desktop. It's been fully integrated into
Visual Studio and ADO.NET Sync Services.
Anything approaching "real SQL" would appear to be an improvement
over Access/Jet data storage. However...
What I'm dealing with here is a small, dedicated-purpose progress
tracking application -- think of it as a special-purpose Information
Manager. It is intended for installation and unsupervised use by
people who only occasionally use their computers, and who are likely
to avoid calling in their organization's IT staff unless Absolutely
Necessary. "Access/.mdb file == My Data" is an extremely clear
paradigm, one that doesn't require much explanation, but if I could
get the same effect with somethign else I'm interested.
Do you know if SQLSCE requires any kind of "user maintenance", say
similar to the need to periodically "compress" an Access2000
database?
How does it relate to the "SQL Server Developer Edition"?
One thing of concern is that while it looks like SQLSCE doesn't
abolutely _require_ Visual Studion 2005, it does look like you lose
a lot of SQLSCE's benefit if you aren't using it (e.g. No VS Tools
for SQLSCE). In my case, I'm using C#.NET/2003, so I'd need to
upgrade.
Per the MS product pages, I'm eligible for the Upgrade package, and
upgrading makes sense, but I didn't see a retail package that
included VS2005 SP1, so I'd need to download and install that. So
far, not unreasonable (assuming the SP1 download doesn't require the
infamous MS "Are You Legal?" checks, which don't seem to work on my
MSWin2K "will touch the Internet over my cold, dead body"
development machine).
My impression -- please correct me if I'm wrong -- is that VS2005
apps will require .NET2.0 If so, do you know if this can be deployed
to Win2K machines? Some of the places this app might run haven't
moved up to XP yet.
Am I starting to sound like a Grumpy Old Man? Probably. <grin!>
All my customer wants is an app that can be installed and will run
without giving her too much grief, for a reasonable cost and in a
reasonable time. Me, I have to worry about stuff like getting
VS2005 running and then, after several days, suddenly discovering
that I'm producing code that half my sites can't run. Upgrades can
be wonderful things... but only after you've successfully upgraded
and everything runs at least as well as before.
On the good side, at least I don't have to do an MVT 21.8 SYSGEN as
part of the upgrade process. <grin!>
Thanks again for the feedback.
Frank
--
"What one writer can make in the solitude of one room is something
no power can easily destroy." -- Salman Rushdie
--
Frank McKenney, McKenney Associates
Richmond, Virginia / (804) 320-4887
Munged E-mail: frank uscore mckenney ayut minds pring dawt cahm (y'all)
.
- References:
- Re: Creating a new Access database file (.mdb) in .NET/C#
- From: Frnak McKenney
- Re: Creating a new Access database file (.mdb) in .NET/C#
- Prev by Date: Re: Creating a new Access database file (.mdb) in .NET/C#
- Next by Date: Re: How to resort records in a dataSet?
- Previous by thread: Re: Creating a new Access database file (.mdb) in .NET/C#
- Next by thread: simple SQL: select missing rows
- Index(es):
Relevant Pages
|
