Solved

SQL / .NET Framework Question

Posted on 2007-03-27
6
212 Views
Last Modified: 2013-12-17
I want to use a SQL database for an application I'm writing.  It was using an Access database, but the database will eventually collapse (a fairly long time from now) because the size will eventually be too large for an Access database.   So, we want to move over to SQL before that happens.  Originally, the usage was that there was a database of x-rays with all the identifying information.  The software just read out of that database to open selected x-rays.  We just want to make that Access database into a SQL database.  However, I've never used SQL before.  I started writing code in MSVS C# 2005 Pro edition using the .NET Framework and the System.Data.Sql namespace.  Now, if I write code with that, will each client computer now have to have an SQL Server on their system?  The application will be the only thing accessing that database and it'll never be accessed over the network.

So, the main question is, "will an installation of a SQL server be absolutely required on each client system with the application?"  If I do need a SQL Server installed on each machine, would I be allowed to install MS Sql Server 2005 Express edition on each machine or would that be against the licensing (i never understand EULAs)?

A secondary question is just asking if anybody knows of any good references for using the System.Data.Sql namespace to write a project and also any good references for anything else related to SQL that I should know.
0
Comment
Question by:raw_enha
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 16

Expert Comment

by:rboyd56
ID: 18800091
SQL Server does not need to be installed on each system. You can have each client machine access a remote SQL Server which will store the data in a central location.

However, if the clients will be disconnected at times from the network or if they need to make updates to a separate database than the central server then it might be best to install SQL Server Express on the client machines.

It really depends on the architecture of the application.

But as a general rule all clients can access the same SQL Server as the backend of the application.
0
 

Author Comment

by:raw_enha
ID: 18800223
We don't want everyone to access it centrally.  We want them all to have their own SQL DB on their computer.  Not all of them have internet access.  This is for an application that gets sold to the user.  We needed something better than an Access database though.
0
 
LVL 16

Expert Comment

by:rboyd56
ID: 18800284
Then yes you will need to install SQL Server on each client. SQL Server Express will work for this. It is basically what it is designed for.
0
The Orion Papers

Are you interested in becoming an AWS Certified Solutions Architect?

Discover a new interactive way of training for the exam.

 

Author Comment

by:raw_enha
ID: 18801213
We build the computers before hand for the customer.  So, it will be legal for us to install SQL Server 2005 Express on there before giving them the computer?
0
 
LVL 16

Accepted Solution

by:
rboyd56 earned 500 total points
ID: 18801522
If you are shipping an application that uses SQL Server Express on it I would assume so. SQL Server Express is freely distributable with an application developed in Visual Studio 2005 that uses SQL Server Express.
0
 

Expert Comment

by:climberboy
ID: 18803418
rboyd56 is correct.  Use the Express Version, and make it a dependancy in your application setup project.  It will install automatically when the user installs your application.

For ADO.Net / SQL, use enterprise library.  It's very well thought-out, and you can get a grip on how it works without too much effort.

If you need, email me at eric@pixelninjas.com and I will send you some sample N-Tier code to manage your DAL, BLL, and Front end.

Thanks,

Eric.
0

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…

690 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question