Database Solution

Hi,
I currently have an EVC App that uses pocket access and
ADOCE. I would like to move it to .NET and re-write it in
C#. I would like to move away from ADOCE and pocket
access, and it seems that microsoft is doing the same
thing. What would you folks suggest for using as a DB? I
notice that .NET will use and XML type database, is that
good? I need to store pictures in the database as well,
and I would like to be able to use SQL, but that is not
neccessary as long as I can still search for records. I
think that the built in Database Store that seems to come
with all Pocket PC devices is completely useless. I also
need to be able to copy the database file to a PC and
have the PC version of the App use the same database.

Thanks for any suggestions.

steve
Tue Oct 14 11:59:52 CDT 2003

you can use sql server ce.

namespace is system.data.sqlserverce

hth,

steve


"Chris" <phunction@hotmail.com> wrote in message
news:098501c39273$350cc6f0$a001280a@phx.gbl...
> Hi,
> I currently have an EVC App that uses pocket access and
> ADOCE. I would like to move it to .NET and re-write it in
> C#. I would like to move away from ADOCE and pocket
> access, and it seems that microsoft is doing the same
> thing. What would you folks suggest for using as a DB? I
> notice that .NET will use and XML type database, is that
> good? I need to store pictures in the database as well,
> and I would like to be able to use SQL, but that is not
> neccessary as long as I can still search for records. I
> think that the built in Database Store that seems to come
> with all Pocket PC devices is completely useless. I also
> need to be able to copy the database file to a PC and
> have the PC version of the App use the same database.
>
> Thanks for any suggestions.

Chris
Tue Oct 14 15:37:43 CDT 2003

Thanks, but can the database be transfered to the PC
without the client haveing to have some kind of sql
server installed?

>-----Original Message-----
>you can use sql server ce.
>
>namespace is system.data.sqlserverce
>
>hth,
>
>steve
>
>
>"Chris" <phunction@hotmail.com> wrote in message
>news:098501c39273$350cc6f0$a001280a@phx.gbl...
>> Hi,
>> I currently have an EVC App that uses pocket access and
>> ADOCE. I would like to move it to .NET and re-write it
in
>> C#. I would like to move away from ADOCE and pocket
>> access, and it seems that microsoft is doing the same
>> thing. What would you folks suggest for using as a DB?
I
>> notice that .NET will use and XML type database, is
that
>> good? I need to store pictures in the database as well,
>> and I would like to be able to use SQL, but that is not
>> neccessary as long as I can still search for records. I
>> think that the built in Database Store that seems to
come
>> with all Pocket PC devices is completely useless. I
also
>> need to be able to copy the database file to a PC and
>> have the PC version of the App use the same database.
>>
>> Thanks for any suggestions.
>
>
>.
>

steve
Tue Oct 14 16:03:20 CDT 2003

no...but your client pc could have msde installed and the hand-held could
replicate w/ it.

there's no db that can be "transfered" - as in copied - from pc to hand-held
and be functional on both...that i know of.


"Chris" <phunction@hotmail.com> wrote in message
news:029d01c39293$04e7be10$a401280a@phx.gbl...
> Thanks, but can the database be transfered to the PC
> without the client haveing to have some kind of sql
> server installed?
>
> >-----Original Message-----
> >you can use sql server ce.
> >
> >namespace is system.data.sqlserverce
> >
> >hth,
> >
> >steve
> >
> >
> >"Chris" <phunction@hotmail.com> wrote in message
> >news:098501c39273$350cc6f0$a001280a@phx.gbl...
> >> Hi,
> >> I currently have an EVC App that uses pocket access and
> >> ADOCE. I would like to move it to .NET and re-write it
> in
> >> C#. I would like to move away from ADOCE and pocket
> >> access, and it seems that microsoft is doing the same
> >> thing. What would you folks suggest for using as a DB?
> I
> >> notice that .NET will use and XML type database, is
> that
> >> good? I need to store pictures in the database as well,
> >> and I would like to be able to use SQL, but that is not
> >> neccessary as long as I can still search for records. I
> >> think that the built in Database Store that seems to
> come
> >> with all Pocket PC devices is completely useless. I
> also
> >> need to be able to copy the database file to a PC and
> >> have the PC version of the App use the same database.
> >>
> >> Thanks for any suggestions.
> >
> >
> >.
> >