Looking for performance vs. ease of use comparisons between the two
Hopefully some real world examples too ?
This is for a desktop Winforms/C# app using SQL Server Compact 3.5 and .net 2.0
From stackoverflow
-
Why would you even consider using OleDB?
Kumar : I've some generic db code uses the interfaces e.g. IConnection, ICommand etc. to connect to any db would like to reuse if possibleTommy Carlier : That's not a problem. You can do that with SqlServerCe. It plugs very nicely into ADO.NET: you have SqlCeConnection (which inherits from DbConnection and implements IDbConnection), SqlCeCommand, SqlCeDataReader, ... They all implement the correct interfaces.Kumar : That works but requires the extra lines of code The generic solution reads the provider from the config and works as is -
Some guy did a benchmark of the 2 which you can find here http://www.pocketpcdn.com/forum/viewtopic.php?t=11003
0 comments:
Post a Comment