Stack Overflow
Stack Overflow

Questions tagged [rowversion]

91 questions
1
vote
1 answer

SQLite logical clock for row data like rowversion in SQL Server

Does SQLite have anything like SQL Server's rowversion column that will increment every time a row changes? Essentially, I want to have a logical clock for each of my tables that updates whenever a table updates. With this logical clock, my…
Heath Borders
  • 30,998
  • 16
  • 147
  • 256
1
vote
0 answers

How can I map a row_version column?

I must mapping a row_version column in hibernate, I have a SQL Server database and my table has a row_version column on DB this column is declared as timestamp because for SQL Server a rowversion is a special timestamp. How can I map this column in…
user5442782
  • 19
  • 2
1
vote
0 answers

C# optimistic concurrency no respond

I'm trying to add optimistic concurrency to my application by following this tutorial. Unfortunately the app works as if I haven't changed anything. I open two browsers, in both I edit the same line, overwrite the same value and put it at the first…
Jana
  • 11
  • 2
1
vote
1 answer

Converting binary value to string and back to binary?

I have rowversion value that comes from Database in binary format. I need to convert that value to string in order to pass in my front-end code. Then when user submits data back to the server I need to convert that string back to binary. Here is…
espresso_coffee
  • 5,980
  • 11
  • 83
  • 193
1
vote
1 answer

Upsert options: rowversion vs datetime

Many times I need to move the data of a large table (let's call it source) to a clone of it (let's call it target). Due to the large size, instead of just deleting/inserting all, I prefer to upsert. For easiness, let's assume an int PK col named…
George Menoutis
  • 6,894
  • 3
  • 19
  • 43
1
vote
1 answer

Can't get Dapper to handle SQL RowVersion properly

I've got a rowversion column added to my database and I'm trying to get Dapper mapping to populate it properly on my object. My object has... public byte[] RowVersion { get; set; } And I have included the RowVersion column in my query but when I do…
Shane Courtrille
  • 13,960
  • 22
  • 76
  • 113
1
vote
3 answers

How to find the maximum in array of binary(8) using powershell?

I'm trying to find the max by using function ExecuteSqlQuery ($SQLQuery) { try { $Datatable = New-Object System.Data.DataTable $Connection = New-Object System.Data.SQLClient.SQLConnection $Connection.ConnectionString =…
Pavel Galich
  • 45
  • 7
1
vote
0 answers

WVersionManager cannot be applied to anonymous .android.view.View.OnClickListener

I'm trying to add an Update functionality with Button inside the app from android project. Below is the code I'm using , But I'm constantly getting error of WmversionManager (android.app.activity) WVersionManager cannot be applied to anonymous…
Sagar Rawal
  • 77
  • 6
1
vote
0 answers

How can I use a SQL Server column of type rowversion?

With Visual Basic in Visual Studio I am trying to select a row of type rowversion from a SQL Server database. 'version' is a column of type rowversion SELECT [Version] FROM Employees WHERE Employee_id = 1 Then in VB - To get value from version…
Carl
  • 19
  • 1
1
vote
0 answers

Get RowVersion after update

I use Entity Framework 4 with row version. I want to update a row and then receive the new row version. Can I do it without re-access the row in the DB?
TamarG
  • 3,522
  • 12
  • 44
  • 74
1
vote
1 answer

Using "rowversion" as primary key column

I am using SQL Server 2012 and I want to create a "changes" table - it will be populated with data from other table when the second table columns values are changed. I am adding to the "changes" table "datatime2", and "rowversion" columns in order…
gotqn
  • 42,737
  • 46
  • 157
  • 243
0
votes
1 answer

ASP.NET OLTP App - creating new version of records

My question is same as this question - but a little to add on to it. My problem is that the users of my web app are allowed to create new versions of a record. Every new version of a record results in creating corresponding "new versions" in 50…
Lalman
  • 946
  • 2
  • 11
  • 27
0
votes
0 answers

Controlling versions for Data Synchronization for a Data View with RowVersion on joined tables

We have a data API that has to publish data to an external system and keep the data up to date. The external system needs aggregate/summary data from us. We have ROWVERSION columns on all tables involved, but we need to create a view to publish the…
Francois Grobler
  • 480
  • 1
  • 4
  • 11
0
votes
1 answer

EF Core 6 "normal" update method doesn't respect RowVersion expected behavior?

I have a .NET6 API project that allows users to fetch resources from a database (SQL Server), and update them on a web client, and submit the updated resource back for saving to db. I need to notify users if another user has already updated the same…
hablahat
  • 182
  • 1
  • 8
0
votes
1 answer

asp:SqlDataSource with ROWVERSION (TIMESTAMP)

I ran into .NET (Framework, w/ WinForm and WebForms) / MS SQL project where significant tables in the database contain a TIMESTAMP (aka ROWVERSION) column (called tsModified) to prevent concurrency issues. Additionally, this project does not allow…
Ted Krapf
  • 403
  • 3
  • 11
1 2 3
4
5 6 7