Use SqlCompact provider when ConnectionString specifies an sdf file

ThatRendle · ThatRendle · commit 1e6bbdb0b8e9 · 2011-01-23T12:28:53.000Z
diff --git a/Simple.Data.Ado/ProviderHelper.cs b/Simple.Data.Ado/ProviderHelper.cs
@@ -1,6 +1,7 @@
 ﻿using System;
 using System.Collections.Concurrent;
 using System.ComponentModel.Composition.Hosting;
+using System.Data.OleDb;
 using System.Reflection;
 using System.IO;
 
@@ -22,6 +23,13 @@ public static IConnectionProvider GetProviderByFilename(string filename)
 
         private static IConnectionProvider LoadProviderByConnectionString(string connectionString)
         {
+            var connectionStringBuilder = new OleDbConnectionStringBuilder(connectionString);
+
+            if (connectionStringBuilder.DataSource.EndsWith("sdf", StringComparison.CurrentCultureIgnoreCase) && File.Exists(connectionStringBuilder.DataSource))
+            {
+                return GetProviderByFilename(connectionStringBuilder.DataSource);
+            }
+            
             var provider = ComposeProvider("sql");
 
             provider.SetConnectionString(connectionString);
diff --git a/Simple.Data.SqlCe40Test/FindTests.cs b/Simple.Data.SqlCe40Test/FindTests.cs
@@ -19,12 +19,19 @@ public class FindTests
             "TestDatabase.sdf");
 
         [Test]
-        public void TestMethod1()
+        public void TestProviderWithFileName()
         {
             var provider = ProviderHelper.GetProviderByFilename(DatabasePath);
             Assert.IsInstanceOf(typeof (SqlCe40ConnectionProvider), provider);
         }
 
+        [Test]
+        public void TestProviderWithConnectionString()
+        {
+            var provider = ProviderHelper.GetProviderByConnectionString(string.Format("data source={0}", DatabasePath));
+            Assert.IsInstanceOf(typeof(SqlCe40ConnectionProvider), provider);
+        }
+
         [Test]
         public void TestFindById()
         {

Original file line number	Diff line number	Diff line change
`@@ -19,12 +19,19 @@ public class FindTests`
`19`	`19`	`"TestDatabase.sdf");`
`20`	`20`
`21`	`21`	`[Test]`
`22`		`- public void TestMethod1()`
	`22`	`+ public void TestProviderWithFileName()`
`23`	`23`	`{`
`24`	`24`	`var provider = ProviderHelper.GetProviderByFilename(DatabasePath);`
`25`	`25`	`Assert.IsInstanceOf(typeof (SqlCe40ConnectionProvider), provider);`
`26`	`26`	`}`
`27`	`27`
	`28`	`+ [Test]`
	`29`	`+ public void TestProviderWithConnectionString()`
	`30`	`+ {`
	`31`	`+ var provider = ProviderHelper.GetProviderByConnectionString(string.Format("data source={0}", DatabasePath));`
	`32`	`+ Assert.IsInstanceOf(typeof(SqlCe40ConnectionProvider), provider);`
	`33`	`+ }`
	`34`	`+`
`28`	`35`	`[Test]`
`29`	`36`	`public void TestFindById()`
`30`	`37`	`{`