Click here to get back home

Database Question for Microsoft Windows Mobile 5.0

 HomeNewsGroups | Search | About
 microsoft.public.smartphone.developer    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
Database Question for Microsoft Windows Mobile 5.0 sanjain82@gmail.com 03-12-2007
Get Chitika Premium
Posted by sanjain82@gmail.com on March 12, 2007, 3:27 am
Please log in for more thread options
Hi guys,

I would like to know which is the best choice for databse usage in
Microsoft Windows Mobile 5.0? Through my research I got to know there
are two types of databse available for smartphone 5.0.
They are :

1. EDB
2. SQL Mobile 3.0

In whichever method I use to create/access the database, it will be
used by both the apps written in VC++ and VC#. So I just wanna confirm
that which databse method will be advisable to use in both VC++
(native code) and VC# (managed code).

Thanks,
Sanjay


Posted by Amit on March 12, 2007, 5:15 am
Please log in for more thread options
Are you supporting synchorinization with external database?If yes the SQL
Mobile is better option.if not then EDB.Secondly as far as using C# is
concerned, then if you decide to use EDB you would need to P/Invoke the api's
--
Thanks and Regards
Amit Ranjan
blog:http://amitranjan.wordpress.com


"sanjain82@gmail.com" wrote:

> Hi guys,
>
> I would like to know which is the best choice for databse usage in
> Microsoft Windows Mobile 5.0? Through my research I got to know there
> are two types of databse available for smartphone 5.0.
> They are :
>
> 1. EDB
> 2. SQL Mobile 3.0
>
> In whichever method I use to create/access the database, it will be
> used by both the apps written in VC++ and VC#. So I just wanna confirm
> that which databse method will be advisable to use in both VC++
> (native code) and VC# (managed code).
>
> Thanks,
> Sanjay
>
>

Posted by sanjain82@gmail.com on March 12, 2007, 5:47 am
Please log in for more thread options
> Are you supporting synchorinization with external database?If yes the SQL
> Mobile is better option.if not then EDB.Secondly as far as using C# is
> concerned, then if you decide to use EDB you would need to P/Invoke the api's
> --
> Thanks and Regards
> Amit Ranjan
> blog:http://amitranjan.wordpress.com
>
>
>
> "sanjai...@gmail.com" wrote:
> > Hi guys,
>
> > I would like to know which is the best choice for databse usage in
> > Microsoft Windows Mobile 5.0? Through my research I got to know there
> > are two types of databse available for smartphone 5.0.
> > They are :
>
> > 1. EDB
> > 2. SQL Mobile 3.0
>
> > In whichever method I use to create/access the database, it will be
> > used by both the apps written in VC++ and VC#. So I just wanna confirm
> > that which databse method will be advisable to use in both VC++
> > (native code) and VC# (managed code).
>
> > Thanks,
> > Sanjay- Hide quoted text -
>
> - Show quoted text -

Hi Amit,

Thanks for your prompt reply. I am not synchronizing with any external
database at all. This is how my app works. My app gets some data from
the network and stores them on device. So I would like to store them
in the database as it is accessed by many components.

And you say, it is possible to use the edb in c#, then how could you
plz show me some code snippets? I got confused bc from msdn it says
the edb is only used for native code. Could you clarify this?

Thanks,


Posted by Peter Foot [MVP] on March 12, 2007, 12:27 pm
Please log in for more thread options
If you are not already comfortable with P/Invoke then I wouldn't suggest
looking at edb. You'll get up and running much quicker with SQL CE (Also
known as SQL Mobile) and it's much more powerful (SQL query support etc).

Peter

--
Peter Foot
Device Application Development MVP
www.peterfoot.net | www.inthehand.com


>> Are you supporting synchorinization with external database?If yes the SQL
>> Mobile is better option.if not then EDB.Secondly as far as using C# is
>> concerned, then if you decide to use EDB you would need to P/Invoke the
>> api's
>> --
>> Thanks and Regards
>> Amit Ranjan
>> blog:http://amitranjan.wordpress.com
>>
>>
>>
>> "sanjai...@gmail.com" wrote:
>> > Hi guys,
>>
>> > I would like to know which is the best choice for databse usage in
>> > Microsoft Windows Mobile 5.0? Through my research I got to know there
>> > are two types of databse available for smartphone 5.0.
>> > They are :
>>
>> > 1. EDB
>> > 2. SQL Mobile 3.0
>>
>> > In whichever method I use to create/access the database, it will be
>> > used by both the apps written in VC++ and VC#. So I just wanna confirm
>> > that which databse method will be advisable to use in both VC++
>> > (native code) and VC# (managed code).
>>
>> > Thanks,
>> > Sanjay- Hide quoted text -
>>
>> - Show quoted text -
>
> Hi Amit,
>
> Thanks for your prompt reply. I am not synchronizing with any external
> database at all. This is how my app works. My app gets some data from
> the network and stores them on device. So I would like to store them
> in the database as it is accessed by many components.
>
> And you say, it is possible to use the edb in c#, then how could you
> plz show me some code snippets? I got confused bc from msdn it says
> the edb is only used for native code. Could you clarify this?
>
> Thanks,
>



Posted by sanjain82@gmail.com on March 12, 2007, 10:29 pm
Please log in for more thread options
Hi Peter,

Well, thats not the case. I just started development with Microsoft
Smartphone, so for me everything is new. But I want to use the best
option without compromising the performance. I did some more research
and according to that for creation of database I got three options:

1. SQL Mobile
2. EDB
3. XML + Dataset

And my requirement is the database will be used by various components
which could be written in VC++ or VC# and the important thing is the
solution must fit for our use which is small size, many removals
additions from various components.

Would be great if you can help me to find out the best solution for my
current need.

Thanks


wrote:
> If you are not already comfortable with P/Invoke then I wouldn't suggest
> looking at edb. You'll get up and running much quicker with SQL CE (Also
> known as SQL Mobile) and it's much more powerful (SQL query support etc).
>
> Peter
>
> --
> Peter Foot
> Device Application Development MVPwww.peterfoot.net|www.inthehand.com
>
>
>
>
>
> >> Are you supporting synchorinization with external database?If yes the SQL
> >> Mobile is better option.if not then EDB.Secondly as far as using C# is
> >> concerned, then if you decide to use EDB you would need to P/Invoke the
> >> api's
> >> --
> >> Thanks and Regards
> >> Amit Ranjan
> >> blog:http://amitranjan.wordpress.com
>
> >> "sanjai...@gmail.com" wrote:
> >> > Hi guys,
>
> >> > I would like to know which is the best choice for databse usage in
> >> > Microsoft Windows Mobile 5.0? Through my research I got to know there
> >> > are two types of databse available for smartphone 5.0.
> >> > They are :
>
> >> > 1. EDB
> >> > 2. SQL Mobile 3.0
>
> >> > In whichever method I use to create/access the database, it will be
> >> > used by both the apps written in VC++ and VC#. So I just wanna confirm
> >> > that which databse method will be advisable to use in both VC++
> >> > (native code) and VC# (managed code).
>
> >> > Thanks,
> >> > Sanjay- Hide quoted text -
>
> >> - Show quoted text -
>
> > Hi Amit,
>
> > Thanks for your prompt reply. I am not synchronizing with any external
> > database at all. This is how my app works. My app gets some data from
> > the network and stores them on device. So I would like to store them
> > in the database as it is accessed by many components.
>
> > And you say, it is possible to use the edb in c#, then how could you
> > plz show me some code snippets? I got confused bc from msdn it says
> > the edb is only used for native code. Could you clarify this?
>
> > Thanks,- Hide quoted text -
>
> - Show quoted text -



Similar ThreadsPosted
Microsoft, please fix these bug in the Windows Mobile 5.0 Email client! June 24, 2006, 7:34 am
Microsoft endorces shared source for Windows Mobile 5 CF2. September 24, 2006, 12:02 am
Windows Mobile question April 24, 2008, 4:04 am
mobile database syncronization w/ SQL 2000 February 7, 2008, 10:40 pm
Do Window mobile have any database of english Words??? May 29, 2007, 3:24 am
OPEN LETTER TO MICROSOFT REGARDING MOBILE 5.0 SDK August 6, 2006, 7:17 pm
Auto BCC / CC add ins for Microsoft Outlook Mobile February 8, 2007, 5:00 pm
ANN: Microsoft Mobile Development Handbook June 12, 2007, 3:35 am
Does Microsoft Mobile 5.0 support Java script? October 13, 2005, 1:26 am
VERY newbie question on porting internet app from windows xp. January 10, 2006, 10:06 am

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap