sql-server-ce Questions
16
I want to find out whether the table has an identity column or not. Table is unknown to me. I have not done the structure of the table. Using Query?
I am using Sql Server Compact Edition.
Maltreat asked 20/5, 2010 at 7:18
2
Solved
I am trying to write a query that gets table information from a SQL CE database, ready to be put in c#, later to be exported to XML. I need one of the columns to be named 'IDENT' with a boolean val...
Gregggreggory asked 11/3, 2013 at 13:3
6
Solved
I did include the System.Data.SqlServerCe dll, put using System.Data.SqlServerCe; in my code, but when I open the .NET page I get:
The type or namespace name 'SqlServerCe' does not exist in the...
Bib asked 15/7, 2012 at 16:36
4
Solved
I'm trying to update values between two tables in sql server compact edition 4.0. My sql is like below:
UPDATE ei SET ei.EstateID=e.EstateID FROM EstateImages ei
INNER JOIN Estates e ON e.TempKey...
Mannerheim asked 3/8, 2011 at 21:43
5
Solved
I've inherited C# code that has an awful lot of DateTimes where the Kind property is DateTimeKind.Unspecified. These are fed into Datetime.ToUniversalTime() which gives back a UTC datetime (it adds...
Herminahermine asked 26/10, 2016 at 21:55
2
Solved
I am having some problem setting the Identity Seed on the Id column in SQL Compact 4 using the code first approach.
I have tried this
context.Database.ExecuteSqlCommand("DBCC CHECKIDENT ('Members...
Petaliferous asked 31/7, 2012 at 1:56
3
Solved
Do someone know what would be the best way to transform a big SQL Server database to sqlite or SQL Server compact ?
SQL Server database should be around 50-70Gb.
There are some examples on intern...
Antebellum asked 26/9, 2014 at 10:30
7
Solved
i have a table which has two columns i'd fill one of the columns by selecting other table column data but how can i fill the next column cause i can't use VALUE. Here's the code
INSERT INTO Number...
Conifer asked 7/8, 2012 at 15:38
6
Solved
I'm using Visual Studio 2008 Pro.
I'm probably missing something very obvious here, but I've been trying to get the CTP for Sql Server compact 4 to work in my asp.net mvc application. I can find ne...
Sock asked 11/7, 2010 at 14:19
3
Solved
I've spent a day trying to migrate an Entity Framework 6 SQL Server CE to PostgreSQL.
I've copied the database over fine, but I can't seem to get the data provider to work.
Firstly I tried the ol...
Obeah asked 18/4, 2017 at 17:19
6
Solved
I'm trying to parameterise a search query that uses the LIKE keyword with a wildcard. The original sql has dynamic sql like this:
"AND JOB_POSTCODE LIKE '" + isPostCode + "%' "
So I've tried thi...
Reclinate asked 16/12, 2009 at 17:27
2
Solved
sSQL.Append(" SELECT 'X' ");
sSQL.Append(" FROM ProfileInsurancePlanYear ");
sSQL.Append(" WHERE ProfileID = " + profileid.ToString() + " AND CropYear = " + cropyear.ToString());
This was a qu...
Agc asked 2/10, 2011 at 3:13
12
Solved
I got the following error when I used sqlce 4.0 with entityframework 6.0
No Entity Framework provider found for the ADO.NET provider with invariant name 'System.Data.SqlServerCe.4.0'
My app.conf...
Inferential asked 6/11, 2013 at 19:42
3
Solved
I'm writing a program that requires the user to select the active database at application startup. I have a Windows Form that will list the databases stored in a sub-folder of ApplicationData speci...
Tester asked 4/9, 2012 at 15:40
3
Solved
I have created a database and table using Visual Studio's SQL Server Compact 3.5 with a dataset as my datasource. On my WinForm I have a DataGridView with 3 columns. However, I have been unable to ...
Clump asked 12/8, 2012 at 23:1
5
Solved
I have a C# DateTime class and wanted to know how I need to format it in a SQL Server CE query to insert it into the database, I was hoping to have both the date and time inserted in. Currently whe...
Allieallied asked 20/8, 2012 at 2:7
8
Solved
I want to get current identity value of a specific table
Like IDENT_CURRENT('table') in sql server
Chitwood asked 9/7, 2013 at 8:38
5
Solved
I seldomly use SQL and I cannot find anything similar in my archive so I'm asking this simple query question: I need a query which one returns personID and only the first seenTime
Records:
seenID...
Trantrance asked 4/1, 2012 at 15:28
3
Solved
How do i deploy Microsoft SQL Server Compact 4.0?
SQL Server Compact Edition (currently at version 4.0) is:
a free, embedded database that software developers can use for building Windows des...
Azevedo asked 24/5, 2012 at 14:47
4
Is there a way to generate the sql statement for tables in sql server compact ?
same as for sql server express+ ?
Essentially a create table( .... ) statement as output ?
Cotenant asked 2/7, 2009 at 3:41
3
Solved
Okay, so, here's my problem: I have developed a .NET 4.0 (Client Profile) + SQL Server Compact application for someone and that someone reported the following issue: the application doesn't start a...
Reformer asked 30/9, 2011 at 12:54
5
Solved
Entity Framewok Code First "ADO.NET provider not found" with local SQL Server CE DLL's
I am writing a C# application which uses SQL Server CE 4.0 files, which are accessed through the Entity Framework 6.0 via code-first. (The application needs to be able to use local dll's for the SQ...
Pollie asked 13/12, 2013 at 20:38
10
I load data from sdf database in winforms App. I use full path to the database file . Example :
conn = new SqlCeConnection
{
ConnectionString ="Data Source=F:\\My Documents\\Project1\\bin\\Debug...
Osier asked 2/12, 2009 at 15:30
1
Solved
Coming from an extensive SQL Server T-SQL background, I'm having trouble finding any specific documentation describing the differences in T-SQL support between SQL CE and full blown SQL Server. Wha...
Bays asked 30/8, 2010 at 20:12
4
I am creating an application for Windows XP so I am stuck with .Net framework 4.0. I tried to use SQL Server Compact and EF code first but it make an error when update-database.
I wish to put the...
Limbert asked 18/10, 2014 at 15:13
1 Next >
© 2022 - 2024 — McMap. All rights reserved.