Avatar of cmdolcet
cmdolcetFlag for United States of America asked on

Free SQL program

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?
Microsoft SQL ServerVisual Basic.NETSQL

Avatar of undefined
Last Comment
D B

8/22/2022 - Mon
Lee W, MVP

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

Best place to download SQL Express?
SOLUTION
Lee W, MVP

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
D B

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.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
ASKER
cmdolcet

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?
ASKER CERTIFIED SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Scott McDaniel (EE MVE )

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.
ASKER
cmdolcet

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.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
D B

Definitely SQL Express. It is much more lightweight then any of the other versions.
Scott McDaniel (EE MVE )

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.
ASKER
cmdolcet

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?
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
DevAdmin

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

Ok. I will be using VB 2005 for this project. Would SQL Express be integrated that far back?
DevAdmin

In VB 2005 you cannot use entity framework... you can only use ADO.NET
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Kimputer

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, CD

Why are you still using VS2005? There have been thousands of improvements in the past 14 years. VS2017 Community Edition is free
Mark Edwards

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.....
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
ASKER
cmdolcet

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!
D B

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.)
DevAdmin

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.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
D B

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.