3,666 questions
0
votes
1
answer
38
views
SqlCeToolbox: A network-related or instance-specific error occurred while establishing a connection to SQL Server
I am using SQLCEToolbox's Export2SQLCE CLI and I am trying to follow this guide from the official documentation. I used this command from the guide:
exportsqlce "Data Source=C:\so_sample\...
- 167
-1
votes
1
answer
41
views
Check for Double items and then check if certain colomn is empty in SQLITE database
Want to check if there are double items in Column Naam in Table zeeboot , and then i show them in a combobox.
Show the result is not the problem but the Statement is .
This is working
Select Naam FROM ...
- 2,252
0
votes
0
answers
41
views
Binary to base64 in SQL Server Compact edition
I have a SQL Server Compact edition database. I try to export binary data, but I see System.Byte[] instead of value.
I want to convert binary to base64 for export, but base64_encode doesn't work.
I ...
2
votes
0
answers
113
views
How to convert this SQL query to NHibernate IQueryable query?
I have to create a query similar to the one below to paginate a parent-child query:
SELECT v.ProductId, MAX(v.Price) AS Price
FROM Variant v
GROUP BY v.ProductId
ORDER BY Price ASC;
I am using C# ...
0
votes
1
answer
874
views
How to use Scaffold-DbContext in .NET Core for SQL Server Compact (*.sdf File) database
I'm using .NET Core Version 7 and I want to use EF Core to access a SQL Server Compact (*.sdf) database file. What libraries to use and how to use Scaffold-DbContext to build the existing database ...
-3
votes
1
answer
311
views
Reading .sdf file (SQL Server Compact File) in reactnative
I am trying to open a .sdf SQL Server Compact database file directly into my React application. How can I open it in React Native directly, without any server or need of an API?
I am building an app ...
- 35
0
votes
1
answer
79
views
SqlServerCompact EFCore Model Generation
I want to generate a EF Model in a C# WindowsForm project (under .NET6 ) from a SQLServerCompact file.
Using Scaffold-DbContext command (see below) I receive an error:
Method ‘Create’ in type
‘EFCore....
- 165
0
votes
0
answers
42
views
SQL Server Compact toolbox diff script doesn't work
I have two .sdf files and I tried run "Script Database diff" on "SQL Server Compact toolbox for runtime 4.0" to get differences between this two files, I got this as result:
-- ...
0
votes
0
answers
554
views
How to convert PDF binary string into MS SQL Server varBinary(max) datatype in C#
In MS SQL query, I convert the binary string into varbinary(max) and insert the value. It is working fine. but how to convert binary string into varbinary(max) in c# using MS SQL stored procedure.
In ...
-2
votes
1
answer
157
views
Getting the information of a mobile device by connecting to it [duplicate]
Is there any way for a server to obtain some information of the mobile devices that are connected to it like memory size and battery power? Is it possible?
Thanks for any reply in advance.
- 127
0
votes
0
answers
113
views
Keyword not supported Entity Framework C#
I am working on a project that is on .NET Framework 4 and when I enter the Update-Database command in the package manager console, I encounter this error:
Keyword not supported: 'initial catalog'
My ...
- 145
-1
votes
2
answers
87
views
How to avoid writing same code for different types
I'm writing a C# program with SQL Server and SQL Server CE. How can I avoid writing same code like below, variable databasestate is used to see if program should use SQL Server or SQL Server CE.
...
0
votes
1
answer
384
views
How to prevent SQL injection in login page when SQL Server Compact Edition is used as a database [duplicate]
The following is one of my old codes. It uses SQL CE as a database. I want to prevent sql injection in this code.
For preventing sql injection, I need to parameterize sql query.
I don't know how to ...
user18576882
0
votes
2
answers
1k
views
How to check if SQL column datatype is int and change if the condition is true
I want to check if the SQL Server Compact column's datatype is Int, and if it is, change it to Float.
However I am just receiving this message that type is String, whereas the Column Number 7 "...
0
votes
0
answers
320
views
Is SQL Server Express DB replacement for SQL Server CE Compact Edition?
SQL Server CE Compact Edition has officially passed the extended end support date:
https://learn.microsoft.com/en-us/lifecycle/products/microsoft-sql-server-compact-40
is SQL Server Express LocalDB a ...
- 943
-1
votes
1
answer
186
views
Update query with one unique value other one with varying values
Want a query possibly a single query for the below conditions
To be updated value of column 3 and 4 is same for all 4 R2IGTNo column
Sometimes the blend will be up to 3 only, 4th row may not come
In C#...
0
votes
1
answer
1k
views
Locale id is not supported on this operating system. LCID=8192
I am using SQL Server Compact file (.SDF) with my C# Windows application. Some client systems are running it properly but a few of them generating errors.
Locale id is not supported on this operating ...
0
votes
0
answers
146
views
Converting SQL Server database to SQL Server Compact edition file (.sdf) version 3.0
I'm currently creating a solution for a software that were developed in 2005 and beside using some more modern technologies, the company wants to keep supports of the old windows embedded compact ...
- 55
1
vote
1
answer
722
views
NuGet package Microsoft.SqlServer.Compact does not copy native DLLs
I have created a .NET Framework 4.8 C# Class Library project that uses x64 as the TargetFramework.
I have added the NuGet package Microsoft.SqlServer.Compact to the project.
When I build the project, ...
- 359
0
votes
0
answers
28
views
SQL Server CE format query
The following query works fine in MS Access or SQL Server:
SELECT FORMAT(a.Data, "dd/MM/yyyy") as Data
FROM mytable
as I got this error:
ErrorMessage: The column name is not valid. [ Node ...
0
votes
2
answers
786
views
Using Entity Framework with Sql Server Compact Edition without App.Config additions
I am developing a plug-in for Rhinoceros 6 and making editions to App.Config file of Rhinoceros seems impossible so far. App.Config of the plug-in project has no effect on App.Config of Rhinoceros.
...
- 371
0
votes
1
answer
94
views
How to solve this Declare variable Sql?
I am making a quiz app where the user can edit its questions from the database.
What I am trying to do in the code below is that when the user opens the QuizEditForm, and makes a change in the ...
- 11
-3
votes
1
answer
271
views
Invalid column name 'Math' - retrieving data from database
Can someone explain why this is happening? I am trying to retrieve data from mysql database but this error occur but the same code works fine when I retrieve a integer value such as TeacherID. ...
user14897423
1
vote
2
answers
184
views
Join with comma separated values in SQL Server Compact not working
I have 2 table as below
CREATE TABLE [Chart]
(
[Id] BIGINT NOT NULL IDENTITY (1,1),
[Owner] NVARCHAR(100),
[Identifier] NVARCHAR(128) NOT NULL,
[Title] NVARCHAR(100),
[Type] INT NOT ...
- 19k
0
votes
1
answer
115
views
sql CE, table description and others informations
so,
i created a table in Sql CE.
if a run
select *
from INFORMATION_SCHEMA.tables t1
i don't have any informations about it
TABLE__CATALOG TABLE__SCHEMA TABLE__NAME TABLE__TYPE TABLE__GUID ...
- 922