Stack Overflow
Stack Overflow

Questions tagged [vistadb]

VistaDB is an Embedded SQL Database Engine for .Net (SQL Server compatible)

39 questions
1
vote
3 answers

Use of COUNT(DISTINCT myfield)

I am puzzled by a SELECT query I am trying to make. Basically my file has one or more records per invoice, showing its region. I want to find how many invoices each region has. Here is an example of my table Table1 InvNo Region A1 1 A2 …
finch
  • 549
  • 1
  • 6
  • 18
1
vote
1 answer

Obtain 'Identity' setting for a column in VistaDB

I am reading the database schema for VistaDB 4.0 database using the standard ADO.NET 'DbConnection.GetSchema' API. I haven't found a way to obtain the 'Identity' setting for a column? The 'Columns' schema collection doesn't seem to have a column for…
alwayslearning
  • 4,493
  • 6
  • 35
  • 47
1
vote
0 answers

What is the detailed syntax for the 'CREATE DATABASE' statement for VistaDB?

What is the detailed syntax for the 'CREATE DATABASE' statement for VistaDB? The documentation only describes various procedures,functions,operators etc, but nothing on the 'CREATE DATABASE' statement. The 'create database' 'how-to' specifies hard…
alwayslearning
  • 4,493
  • 6
  • 35
  • 47
1
vote
2 answers

How to import from XML file in SQL Server Import and Export Wizard?

I have data and schema for a table as a single XML file. How do I import this using the SQL Server Import and Export Wizard? Should I use a "Flat File Source" as my Data Source? Or what? [For info, I exported the XML from VistaDB, but I have not yet…
finch
  • 549
  • 1
  • 6
  • 18
1
vote
1 answer

EF4 Update model from Database VistaDB issue

Does VistaDB support 'Update model from Database' feature in EF4? I'm receiving this message: " ... 'System.ArgumentNullException' 'Value Cannot be Null' Parameter name: providerInvariantName"
user212175
  • 11
  • 2
1
vote
2 answers

Subsonic with VistaDB?

Is it possible to use Subsonic with VistaDB? I see it as a supported database for Subsonic 3 on the project website, But can't find a T4 template for it? Will I need to use SR or I can use AR? Vikas
Vikas
  • 185
  • 2
  • 6
1
vote
2 answers

Is there any good ORM for VistaDB?

I'm looking for a good ORM for VistaDB database. It's for an small desktop application and it might expand in future. Open source solution will be preferred, but I'm ready to shell out if required. Regards, Vikas
Vikas
  • 185
  • 2
  • 6
1
vote
0 answers

How to use VistaDB in multiuser environment

My requirement is as written below: I have a DotNet(c#) winform application using VistaDB as database. So to support multiuser environment( as VistaDB is serverless Database) I have decided to implement Remobjects SDK to build a server which will…
user1659459
  • 65
  • 8
1
vote
2 answers

Is there a way to migrate SQL Server to Vistadb (Umbraco)

I am on a shared host and whilst in development (umbraco) I think it would be easier to use VistaDB then package up to install to SQL Server. However, I have already started using SQL Server. Is there a way to migrate my SQL Server (2008) database…
Coolcoder
  • 4,036
  • 6
  • 28
  • 35
1
vote
1 answer

create and fill VistaDB database programmatically using c#

Is it possible to create a VistaDB database programmatically using C#. My requirement is that I have a SQL Server database with some thousand rows and I want to programmatically create the same schema and export some hundred rows to an embedded…
jeff
  • 684
  • 1
  • 11
  • 30
0
votes
0 answers

How could I adapt this query to work over multiple years?

This query pulls data from a VistaDB and produces info on the number of courses started in each month of the year from people in different countries. Select c.CountryName As Country, Count (case When Month( ch.CourseStarted ) = 1 Then 1 End) As…
Dom Sinclair
  • 2,458
  • 1
  • 30
  • 47
0
votes
2 answers

How can I merge two select queries with counts of mostly identical columns but one set returns multiple rows

I have two queries that work perfectly: DECLARE @StartDate DATETIME = '2021-11-01 00:00:00'; DECLARE @EndDate DATETIME = '2022-03-16 23:59:59'; DECLARE @SalesEstimateTransactionTypeId INT = 16; DECLARE @SalesOrderTransactionTypeId INT = 15; SELECT…
oldcoder
  • 342
  • 2
  • 12
0
votes
1 answer

TSQL - How can I get the total count in a group as part of a subquery

I need to get the total calls per hour per user for the current day, and then calculate the percentage of incoming calls taken by that user. The purpose in the final analysis is to calculate the percentage of a bonus pot per user per hour. I can…
oldcoder
  • 342
  • 2
  • 12
0
votes
1 answer

How do I configure NLog v4 to use a VistaDB5 database

string connString = string.Format("'{0}';Pooling=False;Open Mode=NonExclusiveReadWrite;Password=Galwaypipe001", path); DatabaseTarget dbt = new DatabaseTarget(); dbt.Name = "NLog Database"; dbt.ConnectionString = connString; //…
David
  • 958
  • 2
  • 12
  • 29
0
votes
1 answer

How to correct sql syntax

I have 2 different table which is tbl_meter and tbl_machines. I am entering data using tbl_meter every day. I am finding dailiy results with following sql syntax. But I have problem with tbl_machines. There is relation between 2 tables with local_no…
Hakan
  • 141
  • 3
  • 16
1
2
3