Code: Select all
CREATE TABLE [dbo].[device] (
[device_id] int IDENTITY(1, 1) NOT NULL,
[name] varchar(64) NOT NULL,
[location] varchar(64) NULL,
PRIMARY KEY CLUSTERED ([device_id] ASC))
Code: Select all
Device := TDevice.Create;
Device.Attach(EntityContext);
Device.Name := 'New Device';
Device.Location := 'New Location';
Device.Save;
ShowMessageFmt('DeviceId: %d', [Device.DeviceId]);
Device.Location := 'City';
Device.Save;
Code: Select all
<Table Name="dbo.device" Member="Devices">
<Type Name="Device" ed:Guid="a95e3ad3-aacb-41db-8f71-8851ea943897">
<Column Name="device_id" Member="DeviceId" Type="Integer" AutoSync="OnInsert" DbType="INT NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" ed:ValidateRequired="True" ed:Guid="e3a7b0eb-65ad-425d-b381-fde58a37b8a4">
<Generator Name="Identity">
<GeneratorParameter Name="GeneratorFires" Value="OnCreate" />
</Generator>
</Column>
<Column Name="name" Member="Name" Type="String" DbType="VARCHAR(64) NOT NULL" CanBeNull="false" UpdateCheck="Never" MaxLength="64" ed:ValidateMaxLength="64" ed:ValidateRequired="True" ed:Guid="52e212f7-3036-45a5-a965-fe0fecb9b713" />
<Column Name="location" Member="Location" Type="String" DbType="VARCHAR(64)" CanBeNull="true" UpdateCheck="Never" MaxLength="64" ed:ValidateMaxLength="64" ed:ValidateRequired="False" ed:Guid="2fe6be0c-2b10-4110-b738-e11aa987edb5" />
</Type>
</Table>