public void SelectAllFrom_UseCache() { var value = new TableWithGuid { Id = Guid.NewGuid(), Text = "Text" }; connection.Save(value); var parent = new ParentTableWithGuid { Key = Guid.NewGuid(), Reference = value }; connection.Save(parent); var grandParent = new GrandParentWithGuid { Key = Guid.NewGuid(), Reference = parent }; connection.Save(grandParent); value = connection.Get <TableWithGuid>(value.Id); var all = connection.SelectAllFrom <GrandParentWithGuid>().Where(x => x.Reference == parent).ToList(); Assert.Equal(value, all[0].Reference.Reference); Assert.Equal("Text", value.Text); }
public BaseIntegrationTest(IDatabaseDriver databaseDriver, string connectionString, bool drop) { var mapper = new Mapper(); connection = FolkeConnection.Create(databaseDriver, mapper, connectionString); transaction = connection.BeginTransaction(); connection.CreateTable <TestPoco>(drop: drop); connection.CreateTable <TestManyPoco>(drop: drop); connection.CreateTable <TestCollection>(drop: drop); connection.CreateTable <TestCollectionMember>(drop: drop); connection.CreateTable <TestOtherPoco>(drop: drop); connection.CreateTable <TestMultiPoco>(drop); connection.CreateTable <Playground>(drop); var parentTableWithGuidMapping = mapper.GetTypeMapping <ParentTableWithGuid>(); parentTableWithGuidMapping.Property(x => x.Key).HasColumnName("KeyColumn"); parentTableWithGuidMapping.HasKey(x => x.Key); connection.CreateOrUpdateTable <TableWithGuid>(); connection.CreateOrUpdateTable <ParentTableWithGuid>(); connection.CreateOrUpdateTable <GrandParentWithGuid>(); testValue = new TableWithGuid { Id = Guid.NewGuid(), Text = "Text" }; connection.Save(testValue); }
public void InsertInto_ObjectWithGuid() { var value = new TableWithGuid { Id = Guid.NewGuid(), Text = "Text" }; connection.InsertInto <TableWithGuid>().Values(value).Execute(); }
public void Load_ObjectWithGuid() { var value = new TableWithGuid { Id = Guid.NewGuid(), Text = "Text" }; connection.Save(value); var result = connection.Load <TableWithGuid>(value.Id); Assert.Equal(value.Id, result.Id); Assert.Equal(value.Text, result.Text); }
public async Task SaveAsync_ObjectWithGuid() { var value = new TableWithGuid { Id = Guid.NewGuid(), Text = "Text" }; await connection.SaveAsync(value); var result = await connection.GetAsync <TableWithGuid>(value.Id); Assert.Equal(value.Id, result.Id); Assert.Equal(value.Text, result.Text); }
public void Select_TableWithGuid_WhereParameter_List() { var value = new TableWithGuid { Id = Guid.NewGuid(), Text = "Text" }; connection.InsertInto <TableWithGuid>().Values(value).Execute(); var values = connection.Select <TableWithGuid, FolkeTuple <TableWithGuid> >().All().From().Where((x, p) => x == p.Item0).Build(connection, value).ToList(); Assert.NotEmpty(values); Assert.Equal(value.Id, values[0].Id); Assert.Equal(value.Text, values[0].Text); }
public void Select_TableWithGuid_WhereObject_List() { var value = new TableWithGuid { Id = Guid.NewGuid(), Text = "Text" }; connection.InsertInto <TableWithGuid>().Values(value).Execute(); var values = connection.Select <TableWithGuid>().All().From().Where(x => x == value).ToList(); Assert.NotEmpty(values); Assert.Equal(value.Id, values[0].Id); Assert.Equal(value.Text, values[0].Text); }
public void Load_ObjectWithGuid_WithAutoJoin() { var value = new TableWithGuid { Id = Guid.NewGuid(), Text = "Text" }; connection.Save(value); var parent = new ParentTableWithGuid { Key = Guid.NewGuid(), Text = "Parent", Reference = value }; connection.Save(parent); var result = connection.Load <ParentTableWithGuid>(parent.Key, x => x.Reference); Assert.Equal(parent.Key, result.Key); Assert.Equal(parent.Text, result.Text); Assert.Equal(value.Id, parent.Reference.Id); Assert.Equal(value.Text, parent.Reference.Text); }