http://www.programmersheaven.com/ Contains the latest posts from the thread 'About MSDE.' posted on the '.NET General' forum at Programmer's Heaven. en Copyright 2013 Programmers Heaven Sat, 18 May 2013 19:08:31 -0700 Sat, 18 May 2013 19:08:31 -0700 Argotic Syndication Framework 2007.3.0.1, http://www.codeplex.com/Argotic http://www.rssboard.org/rss-specification 360 http://www.programmersheaven.com/images/ph.gif http://www.programmersheaven.com/ 88 31 http://www.programmersheaven.com/mb/dotnet/165622/165622/about-msde/ I have a client-server winform app written in c# with data access to SQL<br /> server 2000 via stored procedures. I need to move the app to another<br /> company which don't have SQL server. I will therefore make use of the free MSDE(MS Desktop Engine). I have the following questions:<br /> <br /> 1. Since MSDE don't have any user interface, what is the simpliest method to manage the database? Please don't ask me to use the pre-defined stored procedures.<br /> 2. To make the app more portable in the future, I want to use c# to<br /> establish all tables and stored procedures in MSDE(instead of transfering from SQL server everytime), what is the proper method? Does MSDE have the default databases(like Master and Northwind) and stored procedures so that I can make use of them? However, if I use the default stored-procedure, how if later, I need to use Oracle as the database? The best method is, of course, do everything in c#, is it possible?<br /> 3. I am planning to make the client app capable to connect to other kinds of database. I therefore should use connection string instead of using stored procedure(Right?). How can I perform function of T-SQL like @@IDENTITY ?<br /> <br /> http://www.programmersheaven.com/mb/dotnet/165622/165622/about-msde/ Thu, 16 Jan 2003 20:52:30 -0700 .NET General