Preferred .NET CF database?

Posts   
 
    
Jamanga
User
Posts: 93
Joined: 21-Jul-2006
# Posted on: 27-May-2010 17:00:47   

Hi all

I'm been asked to build my first .NET CF application and am wondering which is the database of choice for this environment?

Obviously I'll be using LLBLGen, and I'm thinking Sql CE 3.5 sounds good, but since this is such a knowledgeable community I'd be really interested in your thoughts/experiences.

Thanks, James

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 28-May-2010 02:54:22   

What are the requirements for the app? Stand-alone, client-server, would you use WebServices, etc.?

David Elizondo | LLBLGen Support Team
Jamanga
User
Posts: 93
Joined: 21-Jul-2006
# Posted on: 28-May-2010 03:20:50   

daelmo wrote:

What are the requirements for the app? Stand-alone, client-server, would you use WebServices, etc.?

Hi Daelmo

The application will be Client/Server with communications occurring remotely, possibly via Radio Frequency. The workflow will be along the lines of:

** -> download information from Server onto Client PDA

... do onsite work - log results

-> Send results back to Server. **

I'm not in control of the Server application, but I doubt this solution will involve Web-Services..

Does this help?

Walaa avatar
Walaa
Support Team
Posts: 14946
Joined: 21-Aug-2005
# Posted on: 28-May-2010 07:58:05   

Your description of the ystem's architecture is not clear enough.

You said it's a client server application, so the client is CF.NET, like mobile phone talking to some server, through web services, right?

And the database would be at the server side, right? Do you have another database localy at the client side? (CF.NET side?) If yes, then SQL CE 3.5 is your database indeed.

Jamanga
User
Posts: 93
Joined: 21-Jul-2006
# Posted on: 28-May-2010 08:05:56   

Walaa wrote:

Your description of the ystem's architecture is not clear enough.

You said it's a client server application, so the client is CF.NET, like mobile phone talking to some server, through web services, right?

And the database would be at the server side, right? Do you have another database localy at the client side? (CF.NET side?) If yes, then SQL CE 3.5 is your database indeed.

Hi - sorry about that. Yes its a mobile device which gets information from the Server initially (the server has its own database). Then the mobile device heads off into the outback and performs various functions such as to other electronic devices + recording responses within its db.

The server can still "send" messages to the mobile devices but these will come in via some proprietory hardware not via web-services.

Hope this helps, sorry for not laying it all out initially.

Walaa avatar
Walaa
Support Team
Posts: 14946
Joined: 21-Aug-2005
# Posted on: 28-May-2010 08:28:35   

Alright then it's SQL CE 3.5

Jamanga
User
Posts: 93
Joined: 21-Jul-2006
# Posted on: 31-May-2010 02:53:12   

Walaa wrote:

Alright then it's SQL CE 3.5

Hi Walaa

Thanks for that. I've done a bit more research and there are some performance complaints which seem to be resolved with http://msdn.microsoft.com/en-us/library/dd938877.aspx so its back to manual queries by the looks cry

Has anyone worked with Sybase's iAnywhere db and have comments on performance?

Walaa avatar
Walaa
Support Team
Posts: 14946
Joined: 21-Aug-2005
# Posted on: 31-May-2010 09:05:50   

Thanks for that. I've done a bit more research and there are some performance complaints which seem to be resolved with http://msdn.microsoft.com/en-us/library/dd938877.aspx so its back to manual queries by the looks

Exactly, and this was discussed here: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=11353

Has anyone worked with Sybase's iAnywhere db and have comments on performance?

As for myself, I don't know if iAnywhere could be any better, but let's home one of the community can answer you.