0

I'm starting to learn database, and I will work with SQLce. Is there some type of library that can assist in creating the proper SQL statements for creating tables etc? (Not for query of the database, as I plan to use LINQ). I'm not thinking an MS library, but some amateur project maybe..

bretddog
  • 5,411
  • 11
  • 63
  • 111

1 Answers1

1

You want to download SQL Server Management Studio Express. The SSMS tools let you connect to SQL CE as well as the full blown SQL Server databases, and best of all it's free. You can create your tables via the GUI, and then instead of saving the table, you could have it show you the SQL script instead and learn that way. Everything you do in the GUI executes T-SQL behind the scenes and you have the option of saving all that SQL and running it yourself.

See this stackoverflow question here too for some more details.

Community
  • 1
  • 1
mattmc3
  • 17,595
  • 7
  • 83
  • 103
  • SSMS does not allow scripting, only GUI table design. For scripting, I have a open source library here: http://exportsqlce.codeplex.com – ErikEJ Dec 22 '10 at 09:33