http://vistadb.myopenid.com/
Name: http://vistadb.myopenid.com/
Score: 1,476.73
Last Seen: 528 days, 2 hours, 27 minutes ago
Member Since: 3 March, 2009
DotNetShoutout
atom rss
2
Shouts

Click back twice to exit WP7 transition page

published 526 days, 13 hours, 31 minutes ago posted by http://vistadb.myopenid.com/http://vistadb.myopenid.com/ 528 days, 2 hours, 28 minutes ago
Sunday, December 11, 2011 12:12:15 PM GMT Friday, December 09, 2011 11:15:16 PM GMT
I have been adding animations to a Windows Phone 7 app that has a panorama control and ran into a problem I have seen others post online. I figured it out, so I thought I would take a minute to explain how. Get ready to add transitions The Silverlight Toolkit is the way you want to go about adding quick and easy animations when a page loads and navigates away from the current page. If you are not familiar with the basics visit the link above, or read this really good tutorial about wp7 page transitio... (more)
category: Metro | clicked: 171 | comment | | source: infinitecodex.com
tags: Windows Phone 7, Silverlight Toolkit, XAML
11
Shouts

Entity Framework 4.1 Release Candidate with Go-Live (with Final Release to follow in a month) - Scott Hanselman

published 792 days, 22 hours, 16 minutes ago posted by iftekharahmedamitiftekharahmedamit 795 days, 10 hours, 24 minutes ago
Sunday, March 20, 2011 3:27:49 AM GMT Thursday, March 17, 2011 3:19:45 PM GMT
I was in Redmond this last week and talked to Jeff Derstadt, the Lead Developer on Entity Framework Code First (or, as I say, EF Magic Unicorn). What's the deal with this new feature in Entity Framework? What about the bad rap that EF got back in the day? What's new in EF4 and how does EF Code First sit on that? Which is the right choice, Model First, Database First or Code First? All of this plus demos in this off-the-cuff interview. There's lots of good info in this video including some insight into mu... (more)
category: Architecture | clicked: 4 | comment | | source: www.hanselman.com
tags: EF, Entity Framework, EF 4.1, Entity Framework 4.1, Entity Framework 4.1 Release Candidate
8
Shouts

EF 4.1 Is Coming (DbContext API & Code First RTW) - ADO.NET team blog

published 805 days, 7 hours, 12 minutes ago posted by iftekharahmedamitiftekharahmedamit 806 days, 1 hour, 56 minutes ago
Monday, March 07, 2011 6:31:51 PM GMT Sunday, March 06, 2011 11:47:51 PM GMT
Our latest EF Feature Community Technology Preview (CTP5) has been out for a few months now. Since releasing CTP5 our team has been working hard on tidying up the API surface, implementing changes based on your feedback and getting the quality up to production ready standards. At the time CTP5 was released we also announced that we would be releasing a production ready go-live in Q1 of 2011 and we are on track to deliver on the commitment. .. (more)
category: Architecture | clicked: 2 | comment | | source: blogs.msdn.com
tags: ADO.NET, EF, Entity Framework, EF 4.1, Entity Framework 4.1
10
Shouts

Using EF 4.1 Code First to support multiple database vendors

published 783 days, 10 hours, 50 minutes ago posted by http://vistadb.myopenid.com/http://vistadb.myopenid.com/ 789 days, 20 hours, 41 minutes ago
Tuesday, March 29, 2011 2:53:38 PM GMT Wednesday, March 23, 2011 5:02:59 AM GMT
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: 22 | comment | | source: infinitecodex.com
tags: VistaDB, Entity Framework 4.1, SQL compact 4
12
Shouts

Gibraltar Software Acquires VistaDB

published 973 days, 13 hours, 13 minutes ago posted by http://vistadb.myopenid.com/http://vistadb.myopenid.com/ 978 days, 18 hours, 55 minutes ago
Monday, September 20, 2010 12:31:05 PM GMT Wednesday, September 15, 2010 6:48:14 AM GMT
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: 26 | 1 comment | | source: infinitecodex.com
tags: VistaDB, SQL
7
Shouts

LINQ Query Pane in VistaDB 4.1

published 1031 days, 8 hours, 32 minutes ago posted by http://vistadb.myopenid.com/http://vistadb.myopenid.com/ 1032 days, 5 hours, 57 minutes ago
Saturday, July 24, 2010 5:11:12 PM GMT Friday, July 23, 2010 7:46:32 PM GMT
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

LINQ Group By with NULL database values

published 1049 days, 11 hours, 4 minutes ago posted by http://vistadb.myopenid.com/http://vistadb.myopenid.com/ 1050 days, 9 hours, 53 minutes ago
Tuesday, July 06, 2010 2:39:43 PM GMT Monday, July 05, 2010 3:50:11 PM GMT
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

ClickOnce applications using VistaDB

published 1051 days, 11 hours, 8 minutes ago posted by http://vistadb.myopenid.com/http://vistadb.myopenid.com/ 1053 days, 7 hours, 50 minutes ago
Sunday, July 04, 2010 2:36:02 PM GMT Friday, July 02, 2010 5:53:56 PM GMT
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

Native .NET Local Storage with VistaDB

posted by http://vistadb.myopenid.com/http://vistadb.myopenid.com/ 1055 days, 5 hours, 18 minutes ago
Wednesday, June 30, 2010 8:25:58 PM GMT
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
tags: SQL Server, desktop, VistaDB, Database
8
Shouts

Speed up blocking functions with PLINQ

published 1055 days, 13 hours, 6 minutes ago posted by http://vistadb.myopenid.com/http://vistadb.myopenid.com/ 1060 days, 5 hours, 42 minutes ago
Wednesday, June 30, 2010 12:37:34 PM GMT Friday, June 25, 2010 8:02:09 PM GMT
I have been studying the new PLINQ and Parallel Task Library in .Net 4 looking for various ways to do things that we can’t do in .Net 2.0.  PLINQ is huge, and there are a lot of new ways to do multi threaded programming using .Net 4.  In this article I want to cover a particular problem I have had many times over the years.  How do you speed up multithreaded apps that are bound by blocking functions, or long running I/O operations? I started looking at this method to speed up some long running file I/O ... (more)
category: Architecture | clicked: 2 | 1 comment | | source: infinitecodex.com
tags: Task Parallel Library, Plinq, Concurrency
7
Shouts

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

published 1061 days, 15 hours, 37 minutes ago posted by http://vistadb.myopenid.com/http://vistadb.myopenid.com/ 1063 days, 9 hours, 23 minutes ago
Thursday, June 24, 2010 10:06:19 AM GMT Tuesday, June 22, 2010 4:20:59 PM GMT
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

Just in Time Debugging CLR Procs

published 1068 days, 12 hours, 7 minutes ago posted by http://vistadb.myopenid.com/http://vistadb.myopenid.com/ 1068 days, 23 hours, 39 minutes ago
Thursday, June 17, 2010 1:36:18 PM GMT Thursday, June 17, 2010 2:05:01 AM GMT
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

Building a plug-in model to load VistaDB

published 1068 days, 12 hours, 7 minutes ago posted by http://vistadb.myopenid.com/http://vistadb.myopenid.com/ 1069 days, 3 hours, 3 minutes ago
Thursday, June 17, 2010 1:36:18 PM GMT Wednesday, June 16, 2010 10:40:54 PM GMT
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
7
Shouts

Understanding LINQ to SQL (10) Implementing LINQ to SQL Provider - Dixin's Blog

published 1074 days, 15 hours, 25 minutes ago posted by jrspinellajrspinella 1075 days, 9 hours, 23 minutes ago
Friday, June 11, 2010 10:18:48 AM GMT Thursday, June 10, 2010 4:20:20 PM GMT
[LINQ via C# series] So far LINQ to SQL data CRUD (Creating / Retrieving / Updating / Deleting) has been explained. This post takes a deeper look at the internal implementation of LINQ to SQL query.The provider model Unlike IEnumerable / IEnumerable (more)
category: Web Dev | clicked: 0 | comment | | source: weblogs.asp.net
tags: SQL, Linq
3
Shouts

Exposing OData from an Entity Framework Model

published 1074 days, 15 hours, 25 minutes ago posted by http://vistadb.myopenid.com/http://vistadb.myopenid.com/ 1075 days, 10 hours, 53 minutes ago
Friday, June 11, 2010 10:18:48 AM GMT Thursday, June 10, 2010 2:50:41 PM GMT
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

Building a Dynamic LINQ to Entities Compiler (Part 2)

published 1075 days, 16 hours, 47 minutes ago posted by http://vistadb.myopenid.com/http://vistadb.myopenid.com/ 1076 days, 9 hours, 45 minutes ago
Thursday, June 10, 2010 8:56:59 AM GMT Wednesday, June 09, 2010 3:58:50 PM GMT
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

Compare Date only in Datetime field in T-SQL

published 1077 days, 14 hours, 54 minutes ago posted by PraveenPraveen 1078 days, 13 hours, 17 minutes ago
Tuesday, June 08, 2010 10:49:46 AM GMT Monday, June 07, 2010 12:27:02 PM GMT
This is simple still I want to share as this is asked by so many people around. So, here is the scenario why it's needed. [Mainly in reporting.] From the UI, users selects the date and by using that date we need to compare the datetime field in database and produce some result. But, in database it actually the datetime field, we can't apply equal operator on it as it fails to do it because of time part. I know, now there is... (more)
category: Data | clicked: 1 | comment | | source: praveenbattula.blogspot.com
tags: Date, T-SQL
5
Shouts

Building a Dynamic LINQ to Entities Compiler (Part 1)

posted by http://vistadb.myopenid.com/http://vistadb.myopenid.com/ 1077 days, 19 hours, 52 minutes ago
Tuesday, June 08, 2010 5:52:07 AM GMT
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
tags: SQL Server, Entity Framework, VistaDB, SQL, Linq
6
Shouts

TSQL Challenge 31 - Managing multiple overlapping date intervals.

published 1081 days, 11 hours, 28 minutes ago posted by jacobsebastianjacobsebastian 1082 days, 19 hours, 39 minutes ago
Friday, June 04, 2010 2:15:10 PM GMT Thursday, June 03, 2010 6:04:11 AM GMT
This challenge is adapted from a budgeting system used in a large company to perform quarterly analysis of what kind of work will be done and where it will be done. Project Managers make plans and the estimated hours of work required from each employee each month end up in a central database. Top managers want to see a synthesis of this by department and profession. Your job is to provide this synthesis using all the other information in that database described below. In particular, we are interested in... (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: tsql challenges, TSQL, puzzles, SQLServer
7
Shouts

What the Heck is “MEF” for, and what Silverlight designers need to know about it? - Don Burnett

published 1079 days, 11 hours, 23 minutes ago posted by iftekharahmedamitiftekharahmedamit 1082 days, 1 hour, 6 minutes ago
Sunday, June 06, 2010 2:21:02 PM GMT Friday, June 04, 2010 12:38:06 AM GMT
No, as a few designers have asked we are not talking METH, a drug that has reached pandemic proportions in this country. We are talking about MEF.. Microsoft’s Managed Extensibility Framework MEF has shipped with .NET 4 and is also available for Silverlight 3 and 4 which seems to be a unfortunately named but incredible and new feature that you will want to know about and use in your applications. check out http://MEF.codeplex.com if you need a Silverlight 3 version... (more)
category: Metro | clicked: 4 | comment | | source: www.uxmagic.com
tags: Silverlight, Managed Extensibility Framework, Silverlight 3, MEF, Silverlight 4, Silverlight 4.0
Previous 1 2 3 4 Next