data connection of .net Framework & .net Compact Framework -- dotnet compact framework

Hezal
9/30/2007 12:58:00 PM

hmm, Thanks Paul.
I will see If I can manage that :p

[quoted text, click to view]

Hezal
10/3/2007 6:26:01 AM

I was planning to do a retaurant management system so I am stuck on what
program to use actually ?
Is it feasible to use SQL Server Compact edition as a basis of database &
not use Express edition ??
Since the project will mosly rely on the database and that wireless system
will just be a part of it, I wasn't sure what to do...
Pleaseeeee Help someone....

[quoted text, click to view]

Hezal
10/3/2007 7:35:03 AM

Thanks Ginny.
I am quite new and trying to gather as much info as I can about .NET & .NET
Compact frameworks, and which SQL to use....

I am planning to have the system with the multiple users therefore I'll use
SQL Express Edition. But maybe it's a silly question: Can I install SQL
Compact and SQL express editions on the same PC, and create the database on
Express. Then create an wireless apllication using this sql compact to
connect to the main database ?

[quoted text, click to view]

Ginny Caughey [MVP]
10/3/2007 10:19:37 AM

SQL Compact is best for standalone apps, whether on the desktop or device.
If your desktop app will require multiuser access across a network, then
you'll want Express or SQL Server there. If the wireless connection is
really available thoughout the restaurant, then you could also access
Express or SQL Server from mobile devices, but connectivity is something
you'll want to test before going down this route. If connectivity is spotty
as is often the case, consider Express or SQL Server for big machines with a
local SQL Compact cache on the mobile devices as Paul suggested. Sync
Services for ADO.Net, currently in beta, is designed to assist with this
scenario, and RDA is also an option for syncing data between mobile devices
and a server.

If your question is more about how to connect to Express from C#, use the
SqlClient namespace on mobile devices just as you would on a desktop. The
only real difference is that if you're using Windows Authentication, you
need to provide the username and password from the mobile app, unlike on the
desktop.

--
Ginny Caughey
Device Application Development MVP

[quoted text, click to view]

Ginny Caughey [MVP]
10/3/2007 10:56:40 AM

Yes, you can install Express and SQL Compact on the same PC. You can write a
PC app that reads from data from Express and creates the SQL Compact
database. You can also write a PC app that reads from a SQL Compact database
and updates the Express database. But if you have a *reliable* wireless
connection, it would be easier to just connect directly to the Express
database from the mobile device.

--
Ginny Caughey
Device Application Development MVP

[quoted text, click to view]

Hezal
10/6/2007 9:12:00 AM

What do u mean by : "it would be easier to just connect directly to the
Express
database from the mobile device."
do U mean that I create the main database from SQL Server and not create any
SQL CE for the mobile application ? If that's the case I would appreciate if
u can clear me on that; how do I meant to add to the database frequently and
get the updates from it so that I don't add duplicate data ??

(Thank you soo much for the quick responses earlier :) )

[quoted text, click to view]

Ginny Caughey [MVP]
10/6/2007 9:13:40 PM

Yes, assuming you have a reliable wireless connection, you could connect to
the SQL Express database directly from the mobile device.

--
Ginny Caughey
Device Application Development MVP

[quoted text, click to view]

Hezal
10/7/2007 1:30:01 PM

ok, Thanks Ginny :)

[quoted text, click to view]

Hezal
10/22/2007 1:03:02 PM

I have decided to use Visual Studio 2005 and use C# as the implememtation
language.
I am searching for the methods for connecting to SQL Server from a mobile
device without creating SQL Server CE and connecting both, as Ginny suggested.
But I am coming across with so much different thing and confused now.
I would appreciate if you can tell me how I can do it..
Has it got anything to do with RemoteSQLCE ?

Thanks,

[quoted text, click to view]

Hezal
10/22/2007 2:04:01 PM

Thanks a lot Ginny :)

[quoted text, click to view]

Ginny Caughey [MVP]
10/22/2007 4:44:00 PM

Hezal,

No you don't need RemoteSqlCE to connect directly to a SQL Server. You just
use th SqlClient namespace as you would on the desktop.

--
Ginny Caughey
Device Application Development MVP

[quoted text, click to view]

Hezal
11/25/2007 3:31:02 PM

Hi,
I've created an SQL Server database and I've created a smart device
application in visual studio 2005. I then added the SQL Server database as a
data source to this project. Then I used one table from the database to
display it on the mobile device's form. I also don't know if thats the right
way to directly access the SQL SERVER database from a mobile device using
SQLClient .
When I build it, there is no error.
But when I debug it through the emulator I get the following error:

this._connection = new System.Data.SqlClient.SqlConnection();
this._connection.ConnectionString = "Data
Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\MainRestaurantManagementdb.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True;";
}

Can anyone help me please?

Thanks,

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about dotnet compact framework

dotnet compact framework : data connection of .net Framework & .net Compact Framework