Visual Studio 2010 Templates for CornerstoneDB Tools

The new database tools from CornerstoneDB are getting closer to beta release and  the development team would like to give a few sneak peeks to some of the CornerstoneDB features and advantages over the next few weeks.

Visual Studio 2010 project templates

All of the CornerstoneDB Tools will include project templates built into Visual Studio 2010. CornerstoneDB users will have the advantage of getting up and running fast using all of the powerful API’s. All project templates can be found under File > New Project > CornerstoneDB within Microsoft’s Visual Studio 2010.

Each of the templates will include all the references to the components required, and a quick start file in either C# or VB.Net that has some basic operations to get your started.  These are not meant to be fully working samples, just the snippets you will need more often for the type of project you are building.

Getting started using CornerstoneDB Tools

Reducing the learning curve was our goal for the project templates.  Quick overview of the most common APIs and how to structure the project help users get started with a minimum of effort trying to figure out what has to be included, what are the using statements, etc.

As an example, choosing a new Script Generation Project will create a new console application project that has the full functionality to create SQL scripts from all of our supported providers (SQL Server, SQL CE, VistaDB and MySql).

static void GenerateScript()
{
    ScriptGenerator generator = new ScriptGenerator();

    //Add you own connection string below to generate a sql script from that database
    generator.ConnectionString = "Put your database connection string here";

    //The provider name to the database the script will be generated from
    //VistaDB, SqlServer, SqlCE or MySql
    generator.SourceProviderName = "Put your source provider name here";

    generator.DestinationProviderName = "Put your destination provider name here";

    //This event will report back and progress or errors during the script 
    //generation progress
    generator.CreateBuildScriptProgress += new 
            EventHandler<ScriptGenerator.BuildScriptProgressEventArgs>
                                      (generator_CreateBuildScriptProgress);

    //This command will write the sql script to a file and even create the file if it 
    //doesnt exist. this examples creates a text file named Script on the C:\ drive.
    generator.WriteScriptToFile(@"C:\Script.txt");
}

CornerstoneDB Tool preview

Over the next few weeks leading up to launch we will be announcing new feature sneak peeks for all of the CornerstoneDB projects and tools.

Anyone interested in our upcoming line of database tools can sign up for early beta access here.