The SQL Server CE is the mobile version of the SQL Server family.
So you need to install only a few DLLs and you've got a running SQL Server environment on their PC.
Also this needs no constant maintenance and not as much computing power as it has no active service.
But where are advantages, the disadvantages are not be far. Unfortunately, these are often concealed from Microsoft, Â and so the naive programmers true then completely surprised to strange limitations.
Just Wenna with your Visual Studio programming in VB.NET, C #, or the like, but these are massive striking.
A Practical Introduction is IHRA in my video tutorial: Vb.net and SQL Server Compact Edition
New objects without Provider Factory Support
As for any other provider type also, there is the Visual Studio especially for the Compact Edition own provider objects.
Advance Denkte software developers using the Provider Factory will, however, experience a nasty surprise here.
Because this support (yet) the CE objects. So here a little but must be tricked.
By the way, if you seek the Compact Edtion objects in vain, you have that extra embed "Add Reference" on.
No true 64-bit support
The server does not support 64-bit technology.
However, since all 32-bit Applikaitonen also run on 64-bit, you can work around this problem, in which one that the server uses his program explicitly as a 32-bit program is compiled (see this article )
No comprehensive data types support
If you just tried instead of SQL Server that use Compact Edition as a database, it can quickly lead to nasty surprises.
Since not stand here the same data types, it can quickly lead to errors when creating tables and columns.
Hiera You can find an overview of the data types gegenübergestelltenÂ
Lack of Object support SqlCeConnection
During testing, I came several times for errors, since some properties are not supported vonm SqlCeConnection- object may or may not be assigned.
So am also encountered the totally funny error message saying that Command timeouts NOT equal to zero may be!
But SqlCeConnection.GetSchema is not supported.
no BulkCopy - Object
For me it was very annoying that there is no object for SqlBulkCopy equivalent thereof.
This enables hineinzuladen entire tables from a foreign source to an existing database table of the SQL server.
Slower processing
Since this running locally, and has no active service, the Compact Edition compared to the larger SQL server versions is much slower.
There are probably a few more things that could be mentioned Hiera, me they are just not noticed. Do you know yet what?
0 comments:
Post a Comment