public void TestIssue131() { var i = new InsertRecord(); var c = new OptimisticConnection((DbConnection)Connection()); Assert.Throws <OptimisticConcurrencyException>(() => c.InsertSql <InsertRecord>("THROW 51000, 'At least one record has changed or does not exist. (CONCURRENCY CHECK)', 1;", i)); }
public void SingleInsertShouldAllowParameters() { InsertRecord i = new InsertRecord(); List<InsertRecord> list = new List<InsertRecord>() { i }; var result = Connection().Insert("InsertIdentityReturn2", i, i.Expand(new { OtherValue = 5 })); Assert.AreEqual(i, result); Assert.AreEqual(1, i.Id); Assert.AreEqual(5, i.Id2); }
public void SingleInsertShouldFillInIdentities() { InsertRecord i = new InsertRecord(); i.Value = 5; var result = Connection().Insert("InsertIdentityReturn", i); Assert.AreEqual(i, result); Assert.AreEqual(1, i.Id); Assert.AreEqual(5, i.Id2); }
public void SingleInsertShouldFillInIdentities() { InsertRecord i = new InsertRecord(); i.Value = 5; var result = Connection().Insert("InsertIdentityReturn", i); Assert.AreEqual(i, result); Assert.AreEqual(1, i.Id); Assert.AreEqual(5, i.Id2); }
public void SingleInsertSqlShouldFillInIdentities() { InsertRecord i = new InsertRecord(); List<InsertRecord> list = new List<InsertRecord>() { i }; // this would normally be INSERT INTO blah VALUES (@blah) SELECT @@SCOPE_IDENTITY var result = Connection().InsertSql<InsertRecord>("SELECT Id=1, Id2=2", i); Assert.AreEqual(i, result); Assert.AreEqual(1, i.Id); Assert.AreEqual(2, i.Id2); }
public void MultipleInsertShouldFillInIdentities() { InsertRecord i = new InsertRecord(); InsertRecord i2 = new InsertRecord(); List<InsertRecord> list = new List<InsertRecord>() { i, i2 }; var result = Connection().InsertList("InsertByTable", list, new { OtherValue = 5, Items = list }); Assert.AreEqual(list, result); Assert.AreEqual(1, i.Id); Assert.AreEqual(2, i.Id2); Assert.AreEqual(2, i2.Id); Assert.AreEqual(2, i2.Id2); }
/// <summary> /// Внесение слова в словарь /// </summary> /// <param name="Word">Слово</param> /// <param name="Count">Кол-во повторений</param> public void InsertWord(string Word, int Count) { try { InsertRecord.Parameters.AddWithValue("@word", Word); InsertRecord.Parameters.AddWithValue("@countofreplayes", Count); InsertRecord.ExecuteNonQuery(); } catch (Exception e) { Program.ConsoleWrite($"Ошибка: {e.Message}", 3); return; } }
public void SingleInsertShouldAllowParameters() { InsertRecord i = new InsertRecord(); List <InsertRecord> list = new List <InsertRecord>() { i }; var result = Connection().Insert("InsertIdentityReturn2", i, i.Expand(new { OtherValue = 5 })); Assert.AreEqual(i, result); Assert.AreEqual(1, i.Id); Assert.AreEqual(5, i.Id2); }
public void SingleInsertSqlShouldFillInIdentities() { InsertRecord i = new InsertRecord(); List <InsertRecord> list = new List <InsertRecord>() { i }; // this would normally be INSERT INTO blah VALUES (@blah) SELECT @@SCOPE_IDENTITY var result = Connection().InsertSql <InsertRecord>("SELECT Id=1, Id2=2", i); Assert.AreEqual(i, result); Assert.AreEqual(1, i.Id); Assert.AreEqual(2, i.Id2); }
private void buttonInsert_Click(object sender, EventArgs e) { if (Selected_Table != "") { if (Validate()) { InsertRecord?.Invoke(Selected_Table); SharedFunctions.AddEditableControls(1, new int[] { 100, 136, 51 }, flowLayoutPanelInsert, new List <string>(), Selected_Table); } else { MessageBox.Show("Values can't be null!"); } } }
public void SingleInsertShouldAllowParameters() { using (var connection = _connectionStringBuilder.OpenWithTransaction()) { connection.ExecuteSql("CREATE PROC InsightTestProcSingleInsert (@OtherValue int) AS SELECT Id=1, Id2=@OtherValue"); InsertRecord i = new InsertRecord(); List<InsertRecord> list = new List<InsertRecord>() { i }; var result = connection.Insert("InsightTestProcSingleInsert", i, i.Expand(new { OtherValue = 5 })); Assert.AreEqual(i, result); Assert.AreEqual(1, i.Id); Assert.AreEqual(5, i.Id2); } }
public void SingleInsertShouldFillInIdentities() { using (SqlTransaction t = _connection.BeginTransaction()) { _connection.ExecuteSql("CREATE PROC InsightTestProc (@Value int) AS SELECT Id=1, Id2=@Value", transaction: t); InsertRecord i = new InsertRecord(); i.Value = 5; var result = _connection.Insert("InsightTestProc", i, transaction: t); Assert.AreEqual(i, result); Assert.AreEqual(1, i.Id); Assert.AreEqual(5, i.Id2); } }
public void SingleInsertShouldFillInIdentities() { using (var connection = _connectionStringBuilder.OpenWithTransaction()) { connection.ExecuteSql("CREATE PROC InsightTestProc (@Value int) AS SELECT Id=1, Id2=@Value"); InsertRecord i = new InsertRecord(); i.Value = 5; var result = connection.Insert("InsightTestProc", i); Assert.AreEqual(i, result); Assert.AreEqual(1, i.Id); Assert.AreEqual(5, i.Id2); } }
public void MultipleInsertShouldFillInIdentities() { InsertRecord i = new InsertRecord(); InsertRecord i2 = new InsertRecord(); List <InsertRecord> list = new List <InsertRecord>() { i, i2 }; var result = Connection().InsertList("InsertByTable", list, new { OtherValue = 5, Items = list }); Assert.AreEqual(list, result); Assert.AreEqual(1, i.Id); Assert.AreEqual(2, i.Id2); Assert.AreEqual(2, i2.Id); Assert.AreEqual(2, i2.Id2); }
public void TestIssue131() { var i = new InsertRecord(); var c = new OptimisticConnection((DbConnection)Connection()); var result = c.InsertSql<InsertRecord>("THROW 51000, 'At least one record has changed or does not exist. (CONCURRENCY CHECK)', 1;", i); }
public ProcessCSV(IRecordServices recordService, IEntityServices entityService, InsertRecord insertRecord) { _recordService = recordService; _entityService = entityService; _InsertRecord = insertRecord; }
public void TestIssue131a() { var i = new InsertRecord(); var c = new OptimisticConnection((DbConnection)Connection()); var result = c.InsertSql <InsertRecord>("PRINT ''", i); }
public void TestIssue131a() { var i = new InsertRecord(); var c = new OptimisticConnection((DbConnection)Connection()); var result = c.InsertSql<InsertRecord>("PRINT ''", i); }
public void MultipleInsertShouldFillInIdentities() { try { _connection.ExecuteSql(@"CREATE TABLE InsightTestTableMultiInsert (ID [int] IDENTITY, ID2 [int] DEFAULT (2), Text [varchar](128), Value int)"); _connection.ExecuteSql(@"CREATE TYPE InsightTestTableTypeMultiInsert AS TABLE (Text [varchar](128), Value int)"); _connection.ExecuteSql(@" CREATE PROC InsightTestProcMultiInsert (@OtherValue int, @Items [InsightTestTableTypeMultiInsert] READONLY) AS INSERT INTO InsightTestTableMultiInsert (Text, Value) OUTPUT inserted.ID, inserted.ID2 SELECT Text, @OtherValue FROM @Items "); InsertRecord i = new InsertRecord(); InsertRecord i2 = new InsertRecord(); List<InsertRecord> list = new List<InsertRecord>() { i, i2 }; var result = _connection.InsertList("InsightTestProcMultiInsert", list, new { OtherValue = 5, Items = list }); Assert.AreEqual(list, result); Assert.AreEqual(1, i.Id); Assert.AreEqual(2, i.Id2); Assert.AreEqual(2, i2.Id); Assert.AreEqual(2, i2.Id2); } finally { Cleanup("IF EXISTS (SELECT * FROM sys.objects WHERE name = 'InsightTestProcMultiInsert') DROP PROCEDURE [InsightTestProcMultiInsert]"); Cleanup("IF EXISTS (SELECT * FROM sys.types WHERE name = 'InsightTestTableTypeMultiInsert') DROP TYPE [InsightTestTableTypeMultiInsert]"); Cleanup("IF EXISTS (SELECT * FROM sys.objects WHERE name = 'InsightTestTableMultiInsert') DROP TABLE [InsightTestTableMultiInsert]"); } }
public void TestIssue131() { var i = new InsertRecord(); var c = new OptimisticConnection((DbConnection)Connection()); var result = c.InsertSql <InsertRecord>("THROW 51000, 'At least one record has changed or does not exist. (CONCURRENCY CHECK)', 1;", i); }
public void AsyncSingleInsertShouldAllowParameters() { using (SqlTransaction t = _connection.BeginTransaction()) { _connection.ExecuteSql("CREATE PROC InsightTestProcSingleInsert (@OtherValue int) AS SELECT Id=1, Id2=@OtherValue", transaction: t); InsertRecord i = new InsertRecord(); List<InsertRecord> list = new List<InsertRecord>() { i }; var result = _connection.InsertAsync("InsightTestProcSingleInsert", i, i.Expand(new { OtherValue = 5 }), transaction: t).Result; Assert.AreEqual(i, result); Assert.AreEqual(1, i.Id); Assert.AreEqual(5, i.Id2); } }