Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / .NET Framework / Compact Framework / March 2007

Tip: Looking for answers? Try searching our database.

Newbie question...Where to start?...(Compact Framework, SQL Server CE)

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
forest demon - 28 Mar 2007 17:22 GMT
i just got a project thrown into my lap....develop client/server apps
for a device running WinCE.

i have the Compact Framework installed as well as SQL Server CE. i'm
developing under VS2005.

questions:
  - diffs between emulation and the actual device(some of this is
apparent)?
  - when working with a client database, where does the .sdf
live(emulation/actual)?
  - what SQL Server CE tools(query analysis, management, etc) to use?
  - interaction between the client(SQL SE) and the server(whatever
DB) through ActiveSync, or what else?
.....and a ton of other questions i imagine.

am i the only one that gets lost in the bowels of the Microsoft site?

thanks folks, i appreciate your patience and any input(book and url
references, etc)

-
d(a)emon
Ginny Caughey [MVP] - 28 Mar 2007 17:52 GMT
That's a lot of questions! So I'll just tackle a few of them:

Usually it's easiest to put the sdf file in the same folder of the
emulator/device as your app. You can set up VS to automatically deploy the
sdf file along with your app for testing. I generally prefer to test on the
actual device if I have one as it's usually faster as well as closer to the
actual experience.

I like SQL Server Management Studio (or SQL Express Sp2 Management Studio)
for testing queries, etc., although you can also use Visual Studio for that.

You can use Activesync to connect to the server for syncing or some other
such as wireless - it just depends on your infrastructure. The actual
syncing can be done using web services, or in the case of SQL Server as the
server also RDA or merge replication. You can also just copy the sdf file to
the desktop and write a desktop app to do the syncing. Again, it depends on
your needs.

Everybody gets lost on Microsoft's huge site, and most of us use a search
engine like MSN or Google to find what we want. Start by looking for SQL
Server Compact Edition Books Online. Also check out
www.microsoft.com/sql/compact for downloads, whitepapers, tutorials and
webcasts.

Signature

Ginny

>i just got a project thrown into my lap....develop client/server apps
> for a device running WinCE.
[quoted text clipped - 19 lines]
> -
> d(a)emon
forest demon - 28 Mar 2007 18:04 GMT
that's good info.  thanks a ton.  i do appreciate you people!

On Mar 28, 10:52 am, "Ginny Caughey [MVP]"
<ginny.caughey.onl...@wasteworks.com> wrote:
> That's a lot of questions! So I'll just tackle a few of them:
>
[quoted text clipped - 47 lines]
>
> - Show quoted text -
Arun - 30 Mar 2007 18:02 GMT
>>Everybody gets lost on Microsoft's huge site, and most of us use a search
>>engine like MSN or Google
I second this, Better use word "newbie" and do a google group search

http://groups.google.com/advanced_group_search

you will get lots of threads discussed the topics helping newbie and
few will
really help you to start with.

http://groups.google.com/group/microsoft.public.dotnet.framework.compactframewor
k/browse_thread/thread/dbfd688a5ac7e7fd/a027759622b671b9?lnk=st&q=tons+of+articl
es+arun&rnum=8#a027759622b671b9


I always feel MSDN is the best book for this,
You can download SQL Mobile books online in this link,
http://download.microsoft.com/download/2/4/8/2482e95d-00fd-4374-bd15-57a8c4c3444
4/SQLMobileBooksOnline.exe


There is an interesting web cast rather many webcast explaining SQL
Mobile, one in that
http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032283150&Ev
entCategory=5&culture=en-US&CountryCode=US


Darren Shaffer's Blog
http://dotnetjunkies.com/WebLog/darrenshaffer/default.aspx

Hope this helps,
Cheers,
Arun
www.innasite.com

>  that's good info.  thanks a ton.  i do appreciate you people!
>
[quoted text clipped - 58 lines]
>
> - Show quoted text -

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.