I'm using LLBL in a solution for both MS SQL Compact and "regular" MS SQL 2008..
I'm wondering if it's ok to use the same DatabaseGeneric project (generated by LLBL) & reference it from the 2 DBSpecific projects (generated by LLBL) targeting different MS SQL server editions?
I'm planning to test it later, but the projects dependencies make the cost of trying this out pretty high.. It will be such a waste of time to try it & fail
Let me know if there's any other alternatives I might be missing out!
Different SQLServer versions are supported through the Compatibility Setting. See: http://bit.ly/92ojkL (online docs) which is the config file setting, or in code, by calling DataAccessAdapter.SetSqlServerCompatibilityLevel
You can set it to a compatibility mode of 7, 2000, 2005+, CE Desktop 3 or CE Desktop 3.5
COmpact framework requires different code so it's not addressable through the same .NET code, simply because it has to be compiled against a different mscorlib, has less classes (some code has to be excluded) and the DQE therefore is different.
I.o.w.: I also don't see why you'd want to fetch data on normal .NET from a compact framework located DB, as that's not possible. If you think about SQL Server compact desktop, that's supported as described above. So, yes, it IS generic, but not transportable to another .NET framework like the compact framework, which is logical, due to its nature of a limited api