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);
}
}
