CREATE TABLE [dbo].[Prices](
	[id] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[TicketID] [int] NOT NULL
        -- остальные поля
 CONSTRAINT [PK_Prices] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[Prices]  WITH CHECK ADD  CONSTRAINT [FK_Prices_Tickets] FOREIGN KEY([TicketID])
REFERENCES [dbo].[Tickets] ([id])
GO

ALTER TABLE [dbo].[Prices] CHECK CONSTRAINT [FK_Prices_Tickets]
GO

CREATE TABLE [dbo].[Tickets](
	[id] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	-- остальные поля
 CONSTRAINT [PK_Tickets] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

ticket = new Ticket();
ticket.Field1 = ...;
.....
ticket.FieldN = ...;

context.Tickets.InsertOnSubmit(ticket);     


Price price = new Price();
price.Ticket = ticket;

price.fieldN = ....;

context.Prices.InsertOnSubmit(price);

context.SubmitChanges();

System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_Tickets'. Cannot insert duplicate key in object 'dbo.Tickets'.
The statement has been terminated.

declare @p0 uniqueidentifier
declare @p1 datetime
...
declare @p22 nvarchar( 38 )

set @p0='C858E109-C074-4FF4-85B3-F777E944F534'
set @p1='Nov  1 2010 12:57:09:690PM'
...
set @p22=N'XXX'

INSERT INTO [dbo].[Tickets]([OrderID], [Date], ....)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, @p16, @p17, @p18, @p19, @p20, @p21, @p22)

SELECT CONVERT(Int,SCOPE_IDENTITY()) AS [value]

Msg  2627 , Level  14 , State  1 , Line  49 
Violation of PRIMARY KEY constraint 'PK_Tickets'. Cannot insert duplicate key in object 'dbo.Tickets'.
The statement has been terminated.

( 1  row(s) affected)

.Net SqlClient Data Provider
System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_Prices'. Cannot insert duplicate key in object 'dbo.Prices'.
The statement has been terminated.

using( .... )
{

var prices = from p in Context.Prices where (p.Ticket.Date >= DateFrom  && p.Ticket.Date < DateTo) select p;
Context.Prices.DeleteAllOnSubmit( prices );  
Context.SubmitChanges();

/* ...... */

var tickets = from t in Context.Tickets where (t.Date >= DateFrom && t.Date < DateTo) select t;
Context.Tickets.DeleteAllOnSubmit(tickets);
Context.SubmitChanges();

}