I'm about to start climbing the .Net learning curve.
Would like to start by reproducing a little application that I already have up
and running using an MS Access front end. It manages information for class
reunions. Seems to have the basics: parent/child records, "Find"
functionality, Add/Change/Delete functionality.. ..
However I don't want to develop just a client/server app shoehorned into .Net.
Instead, I'd like to go the whole nine yards and use .Net DataSets.
I'd like to minimize the number of new things TB dealt with.
Is it realistic to think about implementing DataSets against a JET back end?
(i.e. no stored procedures can be written)
Or should I just bite the bullet an migrate the back end to SQL Server?
--
PeteCresswell
11  1401 
"(Pete Cresswell)" <x@y.z> wrote in message
news:6p******** *************** *********@4ax.c om... I'm about to start climbing the .Net learning curve.
Would like to start by reproducing a little application that I already
have up
and running using an MS Access front end. It manages information for
class
reunions. Seems to have the basics: parent/child records, "Find"
functionality, Add/Change/Delete functionality.. ..
However I don't want to develop just a client/server app shoehorned into
.Net.
Instead, I'd like to go the whole nine yards and use .Net DataSets.
I'd like to minimize the number of new things TB dealt with.
Is it realistic to think about implementing DataSets against a JET back
end?
(i.e. no stored procedures can be written)
Or should I just bite the bullet an migrate the back end to SQL Server?
You don't need to use stored procedures to create datasets. Any query can be
loaded into a dataset using the appropriate DataAdapter, in this case that
would be OleDbDataAdapte r, I believe.
You could use a JET backend through the OleDbClients. Although I would
advise against it ;) Access isn't, in my opionon, a "database"( Not even a
real db, just a file) worth the fuss.
Don't really know what your app is doing, but the MSDE could be a cheap
substitue.
--
Patrik Löwendahl [C# MVP] www.cshrp.net - "Elegant code by witty programmers"
"(Pete Cresswell)" <x@y.z> wrote in message
news:6p******** *************** *********@4ax.c om... I'm about to start climbing the .Net learning curve.
Would like to start by reproducing a little application that I already
have up
and running using an MS Access front end. It manages information for
class
reunions. Seems to have the basics: parent/child records, "Find"
functionality, Add/Change/Delete functionality.. ..
However I don't want to develop just a client/server app shoehorned into
.Net.
Instead, I'd like to go the whole nine yards and use .Net DataSets.
I'd like to minimize the number of new things TB dealt with.
Is it realistic to think about implementing DataSets against a JET back
end?
(i.e. no stored procedures can be written)
Or should I just bite the bullet an migrate the back end to SQL Server?
--
PeteCresswell
"Patrik Lowendahl [C# MVP]" <pa************ **@csharpsweden .com> wrote in
message news:ux******** ******@TK2MSFTN GP12.phx.gbl... You could use a JET backend through the OleDbClients. Although I would
advise against it ;) Access isn't, in my opionon, a "database"( Not even a
real db, just a file) worth the fuss.
Don't really know what your app is doing, but the MSDE could be a cheap
substitue.
MSDE would work, but its a bit of a heavy hammer, don't you think?
If, in this case, this is simply a single user, small application, Access is
probably the right choice, if for no other reason than because it has the
smallest footprint and installation process.
If you want the full functionality of a database and the long term growth
potential that a database can offer by all means go to SQL Server. Has a bit
of a learning curve, but worth it in the long run.
"Daniel O'Connell [C# MVP]" wrote:
"Patrik Lowendahl [C# MVP]" <pa************ **@csharpsweden .com> wrote in
message news:ux******** ******@TK2MSFTN GP12.phx.gbl... You could use a JET backend through the OleDbClients. Although I would
advise against it ;) Access isn't, in my opionon, a "database"( Not even a
real db, just a file) worth the fuss.
Don't really know what your app is doing, but the MSDE could be a cheap
substitue.
MSDE would work, but its a bit of a heavy hammer, don't you think?
If, in this case, this is simply a single user, small application, Access is
probably the right choice, if for no other reason than because it has the
smallest footprint and installation process.
RE/ Access isn't, in my opionon, a "database"( Not even a
real db, just a file) worth the fuss.
Don't really know what your app is doing, but the MSDE could be a cheap
substitue.
100% agreement on the "not a real database"...I just have a limited number of
brain cells available, and wanted to isolate the UI and it's care/feeding from
the back end until I got up to some level of competance there....then I'd
migrate the back end.
This particular app, in it's present niche, actually is a classic
desktop/file-based DB situation. To wit, one user and only a few hundred
records. Temporarily avoding MSDE would also give me easier portability - i.e.
I could just copy a bunch of files to another computer to be able to play with
it somewhere else .... as opposed to having to install MSDE on somebody else's
box.
--
PeteCresswell
Patrick, You could use a JET backend through the OleDbClients. Although I would
advise against it ;) Access isn't, in my opionon, a "database"( Not even a
real db, just a file) worth the fuss.
The main difference between a database and a file is that you can change
data in it without reading the whole file and write it completly again or by
appending data to the end of it.
In my opinion does Access fullfill the first option and not the last.
So why is Access in your opinion not a database?
Cor
I fully agree with your point of a smaller footprint,
although I don't really agree with MSDE being a hammer, it's quite
lightweight IMHO. But as Pete pointed out in a later post, it does requires
different level of SQL knowledge.
--
Patrik Löwendahl [C# MVP] www.cshrp.net - "Elegant code by witty programmers"
"Daniel O'Connell [C# MVP]" <onyxkirx@--NOSPAM--comcast.net> wrote in
message news:ed******** ******@TK2MSFTN GP14.phx.gbl...
"Patrik Lowendahl [C# MVP]" <pa************ **@csharpsweden .com> wrote in
message news:ux******** ******@TK2MSFTN GP12.phx.gbl... You could use a JET backend through the OleDbClients. Although I would
advise against it ;) Access isn't, in my opionon, a "database"( Not even a
real db, just a file) worth the fuss.
Don't really know what your app is doing, but the MSDE could be a cheap
substitue.
MSDE would work, but its a bit of a heavy hammer, don't you think?
If, in this case, this is simply a single user, small application, Access
is probably the right choice, if for no other reason than because it has
the smallest footprint and installation process.
1) There's no real indexing in Access, which makes query optimization
impossible.
2) It's not a server with separate memory managment, thread handling, and
separate process to isolate the database from the rest of the application
and operativsystem.
This is just two things from the top of my head, I haven't been involved in
any evaluation for Access since 2002.
Additionally I don't agree that you can't change data in a file without
loading the whole file. You could easily change rows in a file without
loading anything else then the row. Even in older technologys then .Net
(like vb 6, delphi) and C/C++ you have the possibility to just go to one row
and change the data in it.
So your point 1 would make Access either a file or a database, other factors
makes it a file.
--
Patrik Löwendahl [C# MVP] www.cshrp.net - "Elegant code by witty programmers"
"Cor Ligthert" <no************ @planet.nl> wrote in message
news:%2******** *******@tk2msft ngp13.phx.gbl.. . Patrick,
You could use a JET backend through the OleDbClients. Although I would
advise against it ;) Access isn't, in my opionon, a "database"( Not even a
real db, just a file) worth the fuss.
The main difference between a database and a file is that you can change
data in it without reading the whole file and write it completly again or
by appending data to the end of it.
In my opinion does Access fullfill the first option and not the last.
So why is Access in your opinion not a database?
Cor
Patrick Additionally I don't agree that you can't change data in a file without
loading the whole file. You could easily change rows in a file without
loading anything else then the row. Even in older technologys then .Net
(like vb 6, delphi) and C/C++ you have the possibility to just go to one
row and change the data in it.
This makes it in my opinion exactly a database, maybe not a SQL type
relational database, however the last is not the criteria to be a database.
The first databases where using random keys, the next relative adresses,
however definitly it where databases. And often much faster than the current
ones, however bad to manage.
Cor This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Aristotelis E. Charalampakis |
last post by:
Hi all, this is a newbie question :-)
I was wondering if there was a way to use the switch statement in a manner
that each case statement includes more that a simple value. i.e.:
switch ( myFloat )
{
case >0: // ??? how do i write this ???
|
by: bellparis |
last post by:
I'm a student who tries to use EliCZ's hooking library, AE5.6.
My ultimate purpose which I try to use EliCZ's library is preventing
users from copying data by windows clipboard.
So I Added this code to EliCZ's file 'GlobalCDLL.cpp'.
typedef HANDLE (WINAPI *TGetClipboardData)(UINT);
BYTE GetClipboardDataSpace;
TGetClipboardData OldGetClipboardData =
|
by: farseer |
last post by:
Hi,
based on some posts i read, i am using a dll to allow me to do some
keyboard hooking. this is being called from a C# compactfamework app,
which doesn't support delegates. so, i am using a MessageWindow to
send the key presses to the C# app. My question is: there are times,
depending on the key that is pressed, where i want to suppress the
key..so i'd prefer not to call CallNextHookEx in the dll for those
cases. But because i am...
|
by: Brian Bender |
last post by:
I am trying to write a static utility class that allows me to modify
Application variables in my web application.
My problem is that I cannot figure out what to import or inherit to
allow me to see application objects or even the server object.
Here is my code:
Public Shared RefreshCachedXMLDatasets()
|
by: (Pete Cresswell) |
last post by:
I'm about to start climbing the .Net learning curve.
Would like to start by reproducing a little application that I already have up
and running using an MS Access front end. It manages information for class
reunions. Seems to have the basics: parent/child records, "Find"
functionality, Add/Change/Delete functionality....
However I don't want to develop just a client/server app shoehorned into .Net.
Instead, I'd like to go the...
| | |
by: Ryan Ginstrom |
last post by:
Apropos recent threads about GUI editors, coming from a Win32/WTL C++
background, I actually like the idea of being able to (easily) create GUIs
programmatically.
But I still see a lot of the same tedium: hooking up events to handlers, and
getting data into and out of dialogs. In C++, this is generally handled
through code generation and/or macros, but IMO these are brittle and ugly.
So my question: Is there a Pythonic way to make...
|
by: Chad |
last post by:
Hi, I am a SQL Server programmer using Oracle for the first time.
In our .NET client apps which use a SQL Server back end, we would use Stored
Procedure exclusively for all database access for increased security as well
as the pre-compiled advantage.
To minimize trips to the db server, we would often call SPs that return more
than one recordset. For example:
CREATE Stored Procedure HelloWorld As
|
by: pigeonrandle |
last post by:
Hi,
Has anyone had any experience with hooking messages in other
application windows (like SPY++). I want to listen for WM_MOVE
messages, but can only seem to find examples of Keyboard and Mouse
hooks.
Please (and thankyou),
James Randle.
|
by: qazplm114477 |
last post by:
lets say i have 1 table called Inventory and another table called itemType
Inventory
-itemID -PK
-Desc
-itemID- FK
itemType
-ItemID - PK with relation to inventory.itemID - FK
-ItemName
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
