DotNetShoutout

VistaDB

10
Shouts

Shout it

Using EF 4.1 Code First to support multiple database vendors

published 813 days, 17 hours, 29 minutes ago posted by

http://vistadb.myopenid.com/ 820 days, 3 hours, 20 minutes ago

With the release of the Entity Framework 4.1 I was interested to see how well the code first aspect works with multiple database vendors. Could you use the code first modeling to change the database through a connection string? I thought it might be worth a quick sample app to find out. I have an identical database in both SQL CE 4 and VistaDB 4.1. Since they both have ADO.Net providers for the Entity Framework I decided to use them for this test... (more)

category: Data | clicked: 23 | comment | | source: infinitecodex.com

tags: VistaDB, Entity Framework 4.1, SQL compact 4

12
Shouts

Shout it

Gibraltar Software Acquires VistaDB

published 1003 days, 19 hours, 52 minutes ago posted by

http://vistadb.myopenid.com/ 1009 days, 1 hour, 35 minutes ago

VistaDB, an Embedded SQL Database Engine Used By Thousands of .NET Developers Worldwide, Has Been Acquired By Esymmetrix, Developer of Gibraltar Software, a Suite of Products for Application Monitoring and Customer Support. – Read full press releaseWelcome the new team Please welcome Gibraltar Software as the new team that will drive VistaDB forward. Kendall and the entire Gibraltar team know the product very well, they use it in their own products. Very similar to how I took over VistaDB originally, ... (more)

category: Data | clicked: 27 | 1 comment | | source: infinitecodex.com

tags: VistaDB, SQL

7
Shouts

Shout it

LINQ Query Pane in VistaDB 4.1

published 1061 days, 15 hours, 12 minutes ago posted by

http://vistadb.myopenid.com/ 1062 days, 12 hours, 36 minutes ago

There is a new pane in the Data Builder for VistaDB 4.1. The LINQ query pane is a very handy way to build and test LINQ queries against a simple Entity Framework model. First understand that this pane is a work in progress. It was designed to be an easy way to write LINQ queries (similar to LINQPad) for your VistaDB database. The feature is of limited usefulness since the model cannot be customized at generation, or loaded from your own assembly. But this is where we were with the feature when we ha... (more)

category: Data | clicked: 26 | comment | | source: infinitecodex.com

tags: VistaDB, Linq

8
Shouts

Shout it

LINQ Group By with NULL database values

published 1079 days, 17 hours, 43 minutes ago posted by

http://vistadb.myopenid.com/ 1080 days, 16 hours, 33 minutes ago

LINQ is fantastic for the ability to write queries that express intent much more clearly than the same SQL, or structured code. One problem that I have run into though is handling NULL database values that are part of a group by statement. Grouping by ProductSKU Grouping in LINQ allows you to return sets of data from a collection for a given key value. The group by clause is what the key ends up being in the result set. Lets take a grouping of the Products by the SKU.from p in Products group p ... (more)

category: Data | clicked: 41 | comment | | source: infinitecodex.com

tags: VistaDB, SQL, Group by, Linq

5
Shouts

Shout it

ClickOnce applications using VistaDB

published 1081 days, 17 hours, 47 minutes ago posted by

http://vistadb.myopenid.com/ 1083 days, 14 hours, 29 minutes ago

ClickOnce applications have many benefits including ease of deployment, optional automatic updates and framework requirement checks.The only real complicated issue with ClickOnce is how to deploy the database. I can’t imagine trying to deploy Sql Server as a part of your application! VistaDB is a perfect fit to be embedded in a ClickOnce application due to the ease of XCopy deployment. Our 100% managed engine means you don’t need any permissions on the client side, no installs or registry permissions are... (more)

category: Data | clicked: 7 | comment | | source: infinitecodex.com

tags: ClickOnce, embedded, VistaDB, Database

8
Shouts

Shout it

Native .NET Local Storage with VistaDB

posted by

http://vistadb.myopenid.com/ 1085 days, 11 hours, 57 minutes ago

Distributed applications often need local storage. The requirements for local storage are adequate performance, reliability, integration with your existing tools and ease of deployment. VistaDB scores well on all of these fronts. While compact, VistaDB doesn't skimp on database technologies you'd expect, providing referential integrity, views and stored procedures, and a transaction monitor. Granted, in the Microsoft .NET Framework, all database engines tend to look alike, but the people at Infinite Cod... (more)

category: Data | clicked: 5 | comment | | source: visualstudiomagazine.com

| flag as spam

tags: SQL Server, desktop, VistaDB, Database

7
Shouts

Shout it

Building a plug-in model to load VistaDB - Part II

published 1091 days, 22 hours, 17 minutes ago posted by

http://vistadb.myopenid.com/ 1093 days, 16 hours, 2 minutes ago

Plugins are used in data applications to support more than one provider from a single codebase. The Provider Factories in ADO.Net is one such example, but you cannot work with the provider specific features when you use these factories since they only implement generic ADO.Net functions. If you need to be able to use provider specific functions (like VistaDB’s DDA Pack routines), you have to load the provider somehow. In most cases you put that logic and bindings into a separate assembly and load it w... (more)

category: Data | clicked: 0 | comment | | source: infinitecodex.com

tags: SQL Server, Plug-In, C#, VistaDB

6
Shouts

Shout it

Just in Time Debugging CLR Procs

published 1098 days, 18 hours, 47 minutes ago posted by

http://vistadb.myopenid.com/ 1099 days, 6 hours, 18 minutes ago

This topic comes up frequently when users are writing CLR Procs and Triggers. How do I debug the code that is being hosted by the database? There is a very easy way to do it through the System.Diagnostics.Debugger namespace to launch the just in time debugger for Visual Studio.Prompting the user for the debugger You can prompt the user to attach a debugger at runtime using the System.Diagnostics.Debugger. You would NEVER want to do this at runtime in a production environment! Only for use on your deve... (more)

category: Data | clicked: 1 | comment | | source: infinitecodex.com

tags: SQL Server, VistaDB, Debugging, Clr procedures

6
Shouts

Shout it

Building a plug-in model to load VistaDB

published 1098 days, 18 hours, 47 minutes ago posted by

http://vistadb.myopenid.com/ 1099 days, 9 hours, 42 minutes ago

In this article I will explain how to build an application that uses VistaDB and Microsoft’s SQL Server, without being hard bound against their providers directly. Many companies desire to offer the choice from several database providers in a single product or API. In many cases if you were directly bound, but the provider not installed, you would get a dll not found exception at startup. There are two ways to handle this scenario. The most common method is to use ADO.Net Provider Factories and load... (more)

category: Data | clicked: 1 | comment | | source: infinitecodex.com

tags: SQL Server, VistaDB, Plugin

3
Shouts

Shout it

Exposing OData from an Entity Framework Model

published 1104 days, 22 hours, 4 minutes ago posted by

http://vistadb.myopenid.com/ 1105 days, 17 hours, 32 minutes ago

After reading Scott Hansleman’s article on exposing OData for Stack Overflow I thought it would be nice to update the previous post I did on Ado.net data services to include the new WCF Data Services. WCF Data Services (formerly called Ado.net Data Services, and “Astoria”) can expose OData to callers through a very simple interface. LINQPad was not available to query the interface at the time, so I will also discuss how to use LINQPad to write queries against a Data Service. For my example I am going t... (more)

category: Data | clicked: 5 | comment | | source: infinitecodex.com

tags: Entity Framework, VistaDB, WCF Data Services, OData

5
Shouts

Shout it

Building a Dynamic LINQ to Entities Compiler (Part 2)

published 1105 days, 23 hours, 26 minutes ago posted by

http://vistadb.myopenid.com/ 1106 days, 16 hours, 24 minutes ago

In this article I will continue to explain how to build a dynamic LINQ to Entities compiler for any database provider that supports the Ado.net Entity Framework. See part 1 of building a dynamic linq to entities compiler for background information. This part of the series will cover using the .Net CodeDom Compiler to dynamically execute LINQ queries against an EF model. We are working on a dynamic LINQ query mechanism for the next major release of VistaDB. Our goal is to provide a dynamic LINQ executi... (more)

category: Data | clicked: 9 | comment | | source: infinitecodex.com

tags: LinqPad, Entity Framework, VistaDB, Linq

5
Shouts

Shout it

Building a Dynamic LINQ to Entities Compiler (Part 1)

posted by

http://vistadb.myopenid.com/ 1108 days, 2 hours, 31 minutes ago

In this article I will explain how to build a dynamic LINQ to Entities compiler for any database provider that supports the Ado.net Entity Framework. Due to the wide range of technologies used this article, it will be broken up into two parts as listed below. We are working on a dynamic linq query mechanism for the next major release of VistaDB. Our goal is to provide a LinqPad type of environment in Data Builder for users to write LINQ queries against the database without having to first build an EF m... (more)

category: Data | clicked: 0 | comment | | source: infinitecodex.com

| flag as spam

tags: SQL Server, Entity Framework, VistaDB, SQL, Linq

5
Shouts

Shout it

Use RegEx in SQL with CLR Procs

published 1108 days, 20 hours, 41 minutes ago posted by

http://vistadb.myopenid.com/ 1110 days, 7 hours, 6 minutes ago

Wouldn’t it be handy if you could use regular expressions (RegEx) in your SQL code? You could do some really advanced queries through the ability to specify regular expressions rather than just the simple like % matching you normally use.SQL CLR can do that! Yes, you can use the .Net regex library using a SQL CLR method registered as a SqlFunction. This example uses VistaDB 4, but the same code will work with SQL Server 2005 / 2008, by changing the using namespaces. I will demonstrate the same code i... (more)

category: Data | clicked: 0 | comment | | source: infinitecodex.com

tags: Regular Expression, SQL 2008, VistaDB, Clr procedures

3
Shouts

Shout it

SQL CLR procedure registration for VistaDB databases

published 1110 days, 20 hours, 39 minutes ago posted by

http://vistadb.myopenid.com/ 1111 days, 6 hours, 42 minutes ago

This page discusses how to register methods in a CLR Assembly for use as CLR Functions, CLR Procedures, and CLR Triggers (the process is almost identical). All of these methods must be public statics in a CLR assembly in order to be used from SQL. The methods can instantiate other classes that are not static, but the entry point must be a public static. (more)

category: Data | clicked: 1 | comment | | source: www.vistadb.net

tags: VistaDB, Clr procedures

4
Shouts

Shout it

VistaDB CLR Procs and Functions Intro

published 1111 days, 18 hours, 8 minutes ago posted by

http://vistadb.myopenid.com/ 1112 days, 7 hours, 40 minutes ago

Intro to CLR Stored Procedures and CLR Functions CLR Stored Procedures and Functions are a relatively new way to build extensions for your database. Traditionally stored procedure logic has been written in SQL, but SQL Server 2005 introduced the ability to use CLR code for procedures. Microsoft sometimes calls this SQL CLR as the technology used to load CLR assemblies into SQL Server. Prior to SQL CLR you could only extend SQL Server using C++ dlls that were difficult to build and maintain. (more)

category: Data | clicked: 0 | comment | | source: infinitecodex.com

tags: VistaDB, Clr procedures

6
Shouts

Shout it

Entity Framework Compliance VistaDB vs SQL Server 2008 R2

published 1123 days, 21 hours, 21 minutes ago posted by

http://vistadb.myopenid.com/ 1126 days, 4 hours, 48 minutes ago

We have spent a lot of time on our Entity Framework provider over the past 18 months or so. There is a sample EF provider from Microsoft that illustrates basic points, and if you look at all the open source databases they pretty much all used the default code in their implementations. But what if that sample code doesn’t implement something? Or if it is just plain wrong? *I have to tell you we didn’t expect the results we got from this test at all. * (more)

category: Data | clicked: 0 | comment | | source: infinitecodex.com

tags: Entity Framework, SQL Server 2008, VistaDB

9
Shouts

Shout it

Preparing an Entity Framework model for multi provider support

published 1126 days, 20 hours, 47 minutes ago posted by

http://vistadb.myopenid.com/ 1128 days, 13 hours, 48 minutes ago

I was recently tasked with creating a number of samples testing the compliance of both VistaDB and Microsoft SQL Server with Linq to Entity queries. Each sample tested if the provider was able to execute the query without error and then compare both queries to ensure that both providers returned the same results. To ensure valid test results I needed all queries to be executed against a single entity model for both database providers. Entity Framework was designed in a generic manner for this very purpos... (more)

category: Data | clicked: 1 | comment | | source: infinitecodex.com

tags: SQL Server, VistaDB, Visual Studio, Entity Framework 4

8
Shouts

Shout it

Migrate database schemas using SQL Script Generation

published 1129 days, 18 hours, 13 minutes ago posted by

http://vistadb.myopenid.com/ 1132 days, 15 hours, 28 minutes ago

Migrate database schema across multiple vendor platforms There are many different scenarios for migrating database schema’s between two database providers. It’s not uncommon for a development team to run into issues with their database provider mid cycle, or to just be attempting to support more than one database in the same code. Sometimes you just need to get the schema to another database because you have internal tools that use that vendor for part of your testing. Whatever the reason, moving acr... (more)

category: Data | clicked: 0 | comment | | source: infinitecodex.com

tags: SQL Server, database migrations, VistaDB

5
Shouts

Shout it

CornerstoneDB Tools Beta Signup

posted by

http://vistadb.myopenid.com/ 1132 days, 17 hours, 14 minutes ago

We have officially launched the CornerstoneDB site! Beta signup limited to 100 developers You can signup right now to be eligible for the beta on each of the tools. We are seeking feedback from .Net data developers. Give us your input and we will enter you for a chance to win free copy of each tool as they launch. 100 Developers will be chosen to take part in the Beta program for each tool. Signup today if you are interested in getting early access to these great tools.What is CornerstoneDB? Corne... (more)

category: Data | clicked: 1 | comment | | source: infinitecodex.com

| flag as spam

tags: SQL Server, CornerstoneDB, VistaDB, SQL, mysql, Database

10
Shouts

Shout it

Entity Framework 4 New Operations

published 1131 days, 20 hours, 11 minutes ago posted by

http://vistadb.myopenid.com/ 1133 days, 4 hours, 12 minutes ago

There are some new operations in .Net 4 Entity Framework, this a quick example of each working with VistaDB 4 and Visual Studio 2010. These changes were mostly made to bring LINQ to Entities inline with the other LINQ providers in .Net. Of the list below I think that Single() was the one that most people were confused about because if you used it you would get weird errors that didn’t make a lot of sense. For a complete list of LINQ to Entities operators visit the Supported and Unsupported LINQ Method... (more)

category: Data | clicked: 0 | comment | | source: infinitecodex.com

tags: VistaDB, Entity Framework 4, Linq To Entites

Welcome!

VistaDB

Using EF 4.1 Code First to support multiple database vendors

Gibraltar Software Acquires VistaDB

LINQ Query Pane in VistaDB 4.1

LINQ Group By with NULL database values

ClickOnce applications using VistaDB

Native .NET Local Storage with VistaDB

Building a plug-in model to load VistaDB - Part II

Just in Time Debugging CLR Procs

Building a plug-in model to load VistaDB

Exposing OData from an Entity Framework Model

Building a Dynamic LINQ to Entities Compiler (Part 2)

Building a Dynamic LINQ to Entities Compiler (Part 1)

Use RegEx in SQL with CLR Procs

SQL CLR procedure registration for VistaDB databases

VistaDB CLR Procs and Functions Intro

Entity Framework Compliance VistaDB vs SQL Server 2008 R2

Preparing an Entity Framework model for multi provider support

Migrate database schemas using SQL Script Generation

CornerstoneDB Tools Beta Signup

Entity Framework 4 New Operations

Open ID Login

Standard Login

Forgot Password?

Sign up