We help IT Professionals succeed at work.

Free SQL program

143 Views
Last Modified: 2019-01-16
What is the best option to interface SQL with Visual Studio's  .NET. I have a project that require connection to a SQL data.

If I wanted a free SQL download. where could I find it?
Comment
Watch Question

Lee W, MVPTechnology and Business Process Advisor
CERTIFIED EXPERT
Most Valuable Expert 2013

Commented:
SQL Express?  Microsoft SQL Developer Edition?  Am I missing something?  These have been available for years.

Author

Commented:
Best place to download SQL Express?
Lee W, MVPTechnology and Business Process Advisor
CERTIFIED EXPERT
Most Valuable Expert 2013
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Doug BishopDatabase Developer

Commented:
btw, difference between Express and Dev Edition: The Dev edition is free and is basically a FULL BLOWN SQL Server that is free to use in a dev environment. If you are going to deploy to a production environment, you would need to use SQL Express, which has limitations to the amount of data you can store, etc.
This site will let you view specs of each version.

Author

Commented:
I would basically need it to store at most 999 entries. The database would then be mounted to a Full blown version of SQL for a customer.

So would work best? Dev Edition?
System Engineer | .NET Developer | Microsoft MVP | Technical Speaker
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
Given your specs (<1000 rows), SQL Express is more than powerful enough.

If you're asking how to WORK with SQL Data in .NET, then you use the builtin System.Data.SQL namespace, which includes objects like SQLConnection, SQLCommand, etc etc. This is part of the .NET framework, so it's present on any machine that has the right version of that framework.

Author

Commented:
So for the SQL Express version.

I am only using my program to connect to it which the Database would reside the local PC which is running my software.
Doug BishopDatabase Developer

Commented:
Definitely SQL Express. It is much more lightweight then any of the other versions.
Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
There's also LocalDB, a lightweight version of SQL. I use this for one of my programs that runs completely local to the machine, and it works very well. Very easy to install/configure, and would be more than sufficient for your needs.

If you're going to deploy to an environment that has a true SQL SErver, however, you should develop in an environment like that - i.e. setup a server, install SQL Express, and "connect" to that server just as your client will.

If you're going to deploy to an environment where users have their own unique stand-alone programs, and those programs DO NOT connect to a central database, then LocalDB would work well.

Author

Commented:
Ok great thank you for all the valuable information. I would download from the following location https://www.microsoft.com/en-us/sql-server/sql-server-editions-express

Correct?
DevAdminSystem Engineer | .NET Developer | Microsoft MVP | Technical Speaker
CERTIFIED EXPERT

Commented:
For interface SQL and VB.NET you ca use Entity Framework
http://www.entityframeworktutorial.net/entityframework6/create-entity-data-model.aspx

Author

Commented:
Ok. I will be using VB 2005 for this project. Would SQL Express be integrated that far back?
DevAdminSystem Engineer | .NET Developer | Microsoft MVP | Technical Speaker
CERTIFIED EXPERT

Commented:
In VB 2005 you cannot use entity framework... you can only use ADO.NET
KimputerIT Manager
CERTIFIED EXPERT

Commented:
With that little bit of data, I'd go for MongoDB for ease of use (both in using/developing/maintenance/installation). Thats of course, if NoSQL suits your needs. Much less of bloatware, easier to understand log files, etc etc
David Johnson, CDSimple Geek from the '70s
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
Why are you still using VS2005? There have been thousands of improvements in the past 14 years. VS2017 Community Edition is free
Mark EdwardsChief Technology Officer
CERTIFIED EXPERT

Commented:
YES! cmdolcet.... Why are you using "old" VS2005 when you could be using free software that is much newer!  Microsoft wants to know, and when they figure it out, they'll realize that not everyone wants the latest and greatest.....

Author

Commented:
David I would love to upgrade and I have newer license but when you have custom designs with PLC,Database,Integration BLE its hard to upgrade everything in one go.

thanks for your feedback!
Doug BishopDatabase Developer

Commented:
I'm curious as to what Ermanno offered that you accepted his solution that was not already stated by myself and Lee W. in our comments and links? My link took you to the same location (actually one page prior, but clicking on Feature Comparison took you to the same location.)
DevAdminSystem Engineer | .NET Developer | Microsoft MVP | Technical Speaker
CERTIFIED EXPERT

Commented:
cmdolcet assigns the resolution to Doug Bishop and Lee W. for me there are no problems I joined the Expert Exchange to learn and if I can to share, I do not care about the rankings.
Unfortunately I respond when I can and sometimes I lose the answers of other users I apologize for this.

As you have already written other users if you can use the latest version of Visual Studio in this project you will avoid problems in the future if you have to do it for several years.
Doug BishopDatabase Developer

Commented:
Not trying to be argumentative or anything, and I too am in it for what I can learn and to help others. Typically you give points to the first person who answers the question. Lee provided the link to SQL Express. My link, which followed, provided comparisons of different editions.
It is ultimately up to the author to decide which answer(s) to accept or flag as helpful but I was just interested in his thinking on this one.

Not sure why this particular one stuck out over others but, for some reason, it did. No worries either way.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.