Move away from a database, into dll

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I am dealing with an existing application that has a large set of static
data in a SQL database. It is actually a set of code that has been ported
into different languages and into different applications many times. We
would like to consolodate this so that there is only one set of code to
update and so that it is runnable without network access.

My idea is to move away from the database and compile the code and the data
into a dll that can then be accessed by any application we desire. But I
don't really have any idea where to start in moving away from a database and
bringing the data into a dll.

We would like the dll to be able to be used by web applications and desktop
applicaitons on Windows XP, 2000, and CE.

Any ideas?
 
Denis,

In my opinion will this only go by creating an extra tier (service) in all
your applications, and than having all trouble and benefit from that service
that is running (how that would communicate with CE does not even come in my
mind).

Starting with old code to make a desing is in my opinion never a good start
to make a new architecture.

Be than aware that this than will only work with Net application if you
create this in managed code (VBNet, C#, J# or C++ managed).

Just my thought,

Cor

If you don't get your answer there than it will probably be a hard way with
 
Thanks for the Reply!

I absolutely agree with you. We are not trying to base new architecture on
old code and are well aware that once this is complete we will be redesigning
our existing applications.

It does not necessarily need to be done with managed code, but as it will be
running on Windows machines exclusively I do not see the harm.

My biggest dilema is getting the data into the dll and accessing it at
comparable speeds to the SQL database. I am sure there must be a way to move
this data into some sort of binary format with custom access functions but I
don't know where to start. Can anyone point me in the right direction?

--
Denis Crotty
Application Developer

--------------------------------------------
Maltais Geomatics Inc.
17011 - 105 Avenue, Edmonton, Alberta, Canada T5S 1M5


Cor Ligthert said:
Denis,

In my opinion will this only go by creating an extra tier (service) in all
your applications, and than having all trouble and benefit from that service
that is running (how that would communicate with CE does not even come in my
mind).

Starting with old code to make a desing is in my opinion never a good start
to make a new architecture.

Be than aware that this than will only work with Net application if you
create this in managed code (VBNet, C#, J# or C++ managed).

Just my thought,

Cor

If you don't get your answer there than it will probably be a hard way with
Click to expand...
 
Back
Top