Sql Server Express: Testing sql-commands
-
Dear reader, I am totally new in database-programming. I have available all the standard-books but still, I feel lost in that area. I am working with Sql Server Express-Edition One of my basic questions is: How can I test SQL-commands from any kind of tool. It seems, that the express-edition does not have all the tools installed. Another question is: Is it ok to start programming with "basic Ado.Net" and not focussing on EF or Linq? Best regards
-
Dear reader, I am totally new in database-programming. I have available all the standard-books but still, I feel lost in that area. I am working with Sql Server Express-Edition One of my basic questions is: How can I test SQL-commands from any kind of tool. It seems, that the express-edition does not have all the tools installed. Another question is: Is it ok to start programming with "basic Ado.Net" and not focussing on EF or Linq? Best regards
There are many articles here on CodeProject and elsewhere that will give you a good introduction: SQL for Developers: Basic Data Retrieval[^], http://arcanecode.com/2007/01/25/create-a-sql-server-compact-edition-database-with-c/[^], and http://www.w3schools.com/sql/[^].
-
Dear reader, I am totally new in database-programming. I have available all the standard-books but still, I feel lost in that area. I am working with Sql Server Express-Edition One of my basic questions is: How can I test SQL-commands from any kind of tool. It seems, that the express-edition does not have all the tools installed. Another question is: Is it ok to start programming with "basic Ado.Net" and not focussing on EF or Linq? Best regards
Frygreen wrote:
Another question is: Is it ok to start programming with "basic Ado.Net" and not focussing on EF or Linq?
Oh yes!
Wrong is evil and must be defeated. - Jeff Ello[^]
-
Dear reader, I am totally new in database-programming. I have available all the standard-books but still, I feel lost in that area. I am working with Sql Server Express-Edition One of my basic questions is: How can I test SQL-commands from any kind of tool. It seems, that the express-edition does not have all the tools installed. Another question is: Is it ok to start programming with "basic Ado.Net" and not focussing on EF or Linq? Best regards
I will back Jorgen on this one, do NOT use EF as your data access layer if you intend to become a serious developer who builds data centric solutions. Linq to SQL is basically a disaster wrapped in obscure syntax, learn TSQL and you will reap the benefits your entire career.
Never underestimate the power of human stupidity RAH
-
Dear reader, I am totally new in database-programming. I have available all the standard-books but still, I feel lost in that area. I am working with Sql Server Express-Edition One of my basic questions is: How can I test SQL-commands from any kind of tool. It seems, that the express-edition does not have all the tools installed. Another question is: Is it ok to start programming with "basic Ado.Net" and not focussing on EF or Linq? Best regards
Frygreen wrote:
It seems, that the express-edition does not have all the tools installed.
There are different installation options for SQL Express - the larger "Express with advanced services" or "Express with tools" downloads include Management Studio, whereas the smaller "Express" download doesn't. If you've downloaded the version without the tools, there's a separate "Management Studio"-only download available on the same page: http://www.microsoft.com/en-gb/download/details.aspx?id=29062[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
-
Frygreen wrote:
It seems, that the express-edition does not have all the tools installed.
There are different installation options for SQL Express - the larger "Express with advanced services" or "Express with tools" downloads include Management Studio, whereas the smaller "Express" download doesn't. If you've downloaded the version without the tools, there's a separate "Management Studio"-only download available on the same page: http://www.microsoft.com/en-gb/download/details.aspx?id=29062[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
