sql-server-ce

相关标签：javascript jquery android 多少钱 iPhone

Batched queries with SQL Server Compact 4.0 and alternatives if unsupported?

I\'m trying to execute a query which contains \"batched\" commands, and supposedly this wasn\'t supported by Compact 3.5, however I want to avoid using SQL Express or a bigger solution that makes depl[详细]

2023-04-10 02:31 分类：问答
Time (CLR Timespan) column using EF4.1 Code-First approach and SqlCe 4.0

I\'be been trying to map a Timespan property to a SqlCe 4.0 database using EntityFramework 4.1 Code-First approach, and of course I\'m getting a NotSupportedException sa开发者_运维百科ying there\'s no[详细]

2023-04-09 23:37 分类：问答
SQL Server Compact does not support calls to HasRows property if the underlying cursor is not scrollable."

What does this actually mean? I am stepping through some code and when I look at the properties of my datareader under the locals window in vs2010, the DR.HasRows shows an error:[详细]

2023-04-09 15:01 分类：问答
SQL Server CE - bad performance

I\'m developing an application that uses a SQL Server CE database and I am having trouble with the performance of the queries. For example, a simple query that gets the customer\'s last order:[详细]

2023-04-09 14:38 分类：问答
Converting SQL Server database to local C# database

I have cre开发者_开发百科ated program that uses SQL Server database to store data. After a while (and lots of stored data) I have realized I don\'t need database on the server, local database running[详细]

2023-04-08 16:21 分类：问答
How to view SQL Server Compact Edition 4 blob data in VS 2010

I have a SQL Server CE 4.0 table that has a text blob field (ntext).When I browse the data in VS 2010 SP1 the ntext field does not show any data.[详细]

2023-04-08 14:22 分类：问答
Inserting data doesn't replicate into database

I have a written a sample code to insert data into a table and it says successfully inserted, but when I see the data in database in the database explorer, table shows nothing.[详细]

2023-04-08 10:46 分类：问答
Problem using SQL Server CE with Entity Framework code-first and ASP.NET MVC 3 and mvc miniprofiler

I am attempting to create an ASP.NET MVC 3 application using C#, Entity Framework 4.0 code-first and SQL Server CE, and the automated scaffolding. Everything works fine until I try to actually use a p[详细]

2023-04-07 12:44 分类：问答
Does sql server compact still limit to 4gb

I saw in forums that the limit for an SQL Server compact database is 4gb. Doe开发者_如何学编程s anyone know if this limit has been increased yet, sql server express was recently expanded to 10GB..[详细]

2023-04-07 01:59 分类：问答
using SQL Server Compact Edition in ASP.NET websites

I know next to nothing about databases, but need to store and present user input on my ASP.NET tiny website (up to several thousand records). Should I consider SQL Server Compact Edition? In Microsoft[详细]

2023-04-06 19:44 分类：问答