Native .NET Local Storage with VistaDB(visualstudiomagazine.com)

submitted by vistadb(879) 1 year, 10 months ago

VistaDB is a database engine written entirely in .NET managed code. It's a great solution for distributed applications that need to store data locally. read more...

add a comment |category: ADO.NET |Views: 5

tags: ADO.NET Database another

Building a Dynamic LINQ to Entities Compiler (Part 1)(infinitecodex.com)

submitted by vistadb(879) 1 year, 11 months 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 model. read more...

add a comment |category: Database |Views: 21

tags: Database another

Entity Framework Compliance VistaDB vs SQL Server 2008 R2(infinitecodex.com)

submitted by vistadb(879) 2 years 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. We expected that we probably had some room for improvement and that SQL Server would ace all the tests. Didn’t turn out that way. read more...

add a comment |category: ADO.NET |Views: 2

tags: ADO.NET Database another

10 things you must do to make your desktop database apps better(www.vistadb.net)

submitted by vistadb(879) 2 years, 3 months ago

Each of these items could be a blog post unto themselves, but I am going to try really hard to not be too verbose and just cover the core of the concept and why you need to do it. Everyone knows that any app driven by data is much more than just the app. In most cases the app without a database doesn’t even function, or fails to function properly. If a database is an integral part of your application, then shouldn’t you be doing all you can to ensure it stays healthy and prepare for the worst case events of corruption or dead drives? read more...

add a comment |category: Database |Views: 21

tags: Database another

Mindscape LightSpeed 3 domain modeling and persistence framework(vistadb.net)

submitted by vistadb(879) 2 years, 5 months ago

Mindscape has announced a new version of their dot net ORM tool named Mindscape LightSpeed 3. Version 3 includes support for VistaDB 4 and a lot of other new features. Priced at only $199 per developer (source is available for an extra fee) LightSpeed is a very cost effective tool to add to any developers tool belt. There is also a free version available for databases with less than eight tables if you just want to take the product for a test drive. We recently spoke with John-Daniel Trask of Mindscape about their new release, and adding support for VistaDB 4. read more...

add a comment |category: Database |Views: 5

tags: Database another

Does Silverlight 4 really use .Net 4 assemblies?(vistadb.net)

submitted by vistadb(879) 2 years, 5 months ago

I have gotten a lot of questions from Silverlight users wanting to know if VistaDB will be able to load in Silverlight 4. This would be a great thing if you could actually have a client side database in a Silverlight app. I still am not 100% convinced this is a good idea in most circumstances, but for offline Silverlight apps this would definitely make sense. It would allow you to store data locally in isolated storage on the users machine, and then send it to the server when they next are online. The typical airplane offline app scenario. read more...

1 comment |category: Silverlight |Views: 14

tags: Silverlight another

How Dot Net 4 Side by Side will impact API writers(vistadb.net)

submitted by vistadb(879) 2 years, 5 months ago

As I mentioned in my previous Dot Net 4 strategy blog entry, we have been thinking about how we want to handle Dot Net 4 from an API and runtime standpoint. Just as a little refresher, remember that when I am talking about a .Net 2 assembly it can actually be any of the .Net 2, 3.0, 3.5 or 3.5 SP1 runtimes. They are a layered cake design in that they all use the same base and build up with additional tiers of functionality. You cannot have a .Net 3.5 app without .Net 2 present, doesn’t exist. It turns out there is an interesting new feature in Dot Net 4 to allow side by side running of managed runtimes within the same application. There is a great CLR Inside Out article online that explains probably way more than I will here, but I wanted to point out a few specific parts of the article and how they impact API writers like VistaDB. read more...

add a comment |category: Architecture |Views: 12

tags: Architecture another

Upgrading Dot Net BlogEngine to VistaDB 4(vistadb.net)

submitted by vistadb(879) 2 years, 5 months ago

Our blog uses the excellent Dot Net Blog Engine as our blogging platform. You can use VistaDB as the backend store quite easily. Al Nyveldt’s blog has some great posts about setting up and configuring VistaDB with Blog Engine, but they are all for VistaDB 3.x. The Dot Net Blog Engine knows how to load provider factories, so it is quite easy to update the configuration to talk to VistaDB 4. I did these steps on our blog a while ago and everything has continued to run smoothly. read more...

add a comment |category: Database |Views: 2

tags: Database another

How Dot Net 4 Side by Side will impact API writers(vistadb.net)

submitted by vistadb(879) 2 years, 5 months ago

As I mentioned in my previous Dot Net 4 strategy blog entry, we have been thinking about how we want to handle Dot Net 4 from an API and runtime standpoint. Just as a little refresher, remember that when I am talking about a .Net 2 assembly it can actually be any of the .Net 2, 3.0, 3.5 or 3.5 SP1 runtimes. They are a layered cake design in that they all use the same base and build up with additional tiers of functionality. You cannot have a .Net 3.5 app without .Net 2 present, doesn’t exist. read more...

add a comment |category: Architecture |Views: 18

tags: Architecture another

Using SQL Server Import and Export Wizard with VistaDB(vistadb.net)

submitted by vistadb(879) 2 years, 6 months ago

How can you use the SQL Server Import and Export Wizard to migrate data from VistaDB 4 to SQL Server 2008? There is only one real tricky part that is specific to VistaDB 4, the license setup. SQL Server obviously was not built by you (or us), so it has not built in license for VistaDB. But we already thought of that, and give you a way to add a Design Time license flag to third party applications through their app.config. DTSWizard and the other related tools all have app.config files that you can easily edit as shown in this blog post. read more...

add a comment |category: Database |Views: 16

tags: Database another

VistaDB 4 Lite Edition Released(vistadb.net)

submitted by vistadb(879) 2 years, 7 months ago

The first release of VistaDB 4 Lite (Build 7) is now available! VistaDB Lite is a very low cost embedded SQL database engine that includes many of the features only found in large server systems like Microsoft SQL Server. VistaDB Lite users can utilize the power of CLR Procedures and Triggers to expand the functionality of the default database engine. The VistaDB Lite edition is intended for hobbyists, students, teachers, anyone who needs a small footprint xcopy deployable... read more...

add a comment |category: ADO.NET |Views: 90

tags: ADO.NET Database another

Learning .Net Programming Resources(vistadb.net)

submitted by vistadb(879) 2 years, 7 months ago

There are a lot of areas to learn in .Net programming. I don’t know any programmer who actually knows all of them, the namespace is just too big and complex. I know programmers who specialize only in one small area of the .Net framework and still tell me they learn new things all the time. I wanted to list a few resources that I find invaluable in my day to day programming, and a few sites for those just getting started or just moving to a new area of .Net. These resources are great tools for dot net developers of any experience, not just people starting out. read more...

add a comment |category: CLR |Views: 53

tags: CLR another

The SQL Server natural order query myth(vistadb.net)

submitted by vistadb(879) 2 years, 7 months ago

There is this myth among developers and DBAs that SQL Server has a natural order that is logical and predictable (and can therefore be relied on). Not so! I wanted to take a few moment to explain and debunk the myth, explain how VistaDB is different, and share something I learned along the way. The Myth(s) SQL Server stores entries in a natural order based upon the first column. SQL Server always appends inserted rows at the end of the current table. Unindexed data is always available in the order it was inserted. Dot Net developers often don't care about these things, but they should. read more...

add a comment |category: ADO.NET |Views: 9

tags: ADO.NET Database another

VistaDB 4.0 Preview 1 with Entity Framework support released(vistadb.net)

submitted by vistadb(879) 2 years, 8 months ago

VistaDB 4.0 Preview Release 1 includes the new engine, DataBuilder changes for color syntax highlighting, Entity Framework and much more. VistaDB 4.0 Preview 1 is for existing customers only, but you can purchase a license before release at a large discount and get instant access to both 3.5 and 4.0. read more...

add a comment |category: ADO.NET |Views: 12

tags: ADO.NET Database another

How does the Entity Framework get relationships from the database?(vistadb.net)

submitted by vistadb(879) 2 years, 10 months ago

I put together a brief video showing some relationships in the NorthwindEF model, and how they relate to the VistaDB database. The Foreign Keys in VistaDB may seem a little backwards from how SQL Server generates them. For VistaDB you should go to the table you want the dependency contained in and generate the Foreign Key. read more...

add a comment |category: ADO.NET |Views: 10

tags: ADO.NET Database another

ASP.Net Databound example using EntityDataSource(vistadb.net)

submitted by vistadb(879) 2 years, 10 months ago

Microsoft included a new DataSource control for Asp.net developers with the Entity Framework. The EntityDataSource lets you perform data binding to Entities using a wizard in Visual Studio. Video demonstration of how to use the new binding to create a quick webpage. read more...

add a comment |category: ADO.NET |Views: 78

tags: ADO.NET Database another