.NET General

Moderators: None (Apply to moderate this forum)
Number of threads: 797
Number of posts: 1359

This Forum Only
Post New Thread
Single Post View       Linear View       Threaded View      f

Report
About MSDE. Posted by kennon2000 on 16 Jan 2003 at 8:52 PM
I have a client-server winform app written in c# with data access to SQL
server 2000 via stored procedures. I need to move the app to another
company which don't have SQL server. I will therefore make use of the free MSDE(MS Desktop Engine). I have the following questions:

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.
2. To make the app more portable in the future, I want to use c# to
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?
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 ?




 

Recent Jobs

Official Programmer's Heaven Blogs
Web Hosting | Browser and Social Games | Gadgets

Popular resources on Programmersheaven.com
Assembly | Basic | C | C# | C++ | Delphi | Flash | Java | JavaScript | Pascal | Perl | PHP | Python | Ruby | Visual Basic
© Copyright 2011 Programmersheaven.com - All rights reserved.
Reproduction in whole or in part, in any form or medium without express written permission is prohibited.
Violators of this policy may be subject to legal action. Please read our Terms Of Use and Privacy Statement for more information.
Operated by CommunityHeaven, a BootstrapLabs company.