Questions tagged [sql-server-ce]
The sql-server-ce tag has no usage guidance.
sql-server-ce
3,674
questions
2
votes
0
answers
59
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
0
answers
19
views
Building an application for phones on flutter flow that can connect to a desktop Program in java
I'm trying to build a mobile application for my School's Dentist. I can build it on flutter flow, and I can build the program in java for GUI thanks to YouTube. I still don't know how can I connect ...
- 1
0
votes
0
answers
51
views
Unable to get last entry from SQL Server Compact Edition Database Through Group By And Order By Functions
I have a SQL Server Compact database with two tables:
Consumers
Monthly Bills
Each month's bill is stored in the monthly bill table, I want to get consumers with the last month bill stored in the ...
0
votes
1
answer
614
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 ...
0
votes
0
answers
31
views
Needs to uncheck sysadmin role of domain user in SQL Server
We've established connections between SQL Server views and Excel, utilizing pivot tables within Excel sheets for data analysis. Recently, we were directed to modify the sysadmin server role of a ...
0
votes
0
answers
152
views
error while creating SSAS cube with SQL Server CE
I am failing to create a cube in SSAS from a SDF file (SQL CE) as a datasource.
I am assuming it's possible because SQL CE supports OLEDB interface. I am doing this in C# with AMO library.
The error I'...
- 181
-3
votes
1
answer
195
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
1
vote
0
answers
203
views
SQL Server CE Database Larger than Max Size - How can I regain access to this file to delete old data, compact and shrink the file?
I have a large SQL Server CE .sdf file with lots of historical data in it. Recently, the file hit the max file size limit for both my connection string and SQL Server CE.
I'm trying to use SQLCECmd40....
- 16.4k
0
votes
1
answer
60
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....
- 135
0
votes
1
answer
512
views
How to connect to SQL Server CE database from ASP.NET Core Web API application
I have connected to my SQL Server Compact Edition database from an ASP.NET console application. I am using the same thing and libraries to connect to SQL Server CE database file in my ASP.NET Core Web ...
- 76
0
votes
0
answers
31
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
25
views
System.Data.SqlServerCe.HashSafeHandle" could not release handle with value 0x08D7E430
I am getting this error:
System.Data.SqlServerCe.HashSafeHandle" could not release handle with value 0x08D7E430
suddenly using
System.Data.SqlServer_Ce_unofficial
and then calling this simple ...
- 11.2k
0
votes
0
answers
458
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 ...
0
votes
0
answers
448
views
How to connect SQL Server Compact Edition database .sdf file to ADO Connection
I am trying to use a small .sdf database file created in SQL Server Compact Edition version 4.0 on Delphi application, but I cannot make a connection (ADO Connection) to this database. I have Windows ...
- 23
-2
votes
1
answer
141
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.
- 117