LINQ -- Primary Key , Foriegn Key Association Is very confusing in Many -ti-many relationships ..
-
Hello all I have three tables First 1 -------------------- with These Fileds CREATE TABLE [dbo].[Category]( [CategoryID] [int] IDENTITY(1,1) NOT NULL, [Name] [nvarchar](400) NOT NULL, [Description] [nvarchar](max) NOT NULL, [TemplateID] [int] NOT NULL, [MetaKeywords] [nvarchar](400) NOT NULL, [MetaDescription] [nvarchar](4000) NOT NULL, [MetaTitle] [nvarchar](400) NOT NULL, [SEName] [nvarchar](100) NOT NULL, [ParentCategoryID] [int] NOT NULL, [PictureID] [int] NOT NULL, [PageSize] [int] NOT NULL CONSTRAINT [DF_Nop_Category_PageSize] DEFAULT ((10)), [PriceRanges] [nvarchar](400) NOT NULL CONSTRAINT [DF_Nop_Category_PriceRanges] DEFAULT (''), [ShowOnHomePage] [bit] NOT NULL CONSTRAINT [DF_Nop_Category_ShowOnHomePage] DEFAULT ((0)), [Published] [bit] NOT NULL, [Deleted] [bit] NOT NULL, [DisplayOrder] [int] NOT NULL, [CreatedOn] [datetime] NOT NULL, [UpdatedOn] [datetime] NOT NULL, Table 2 -- CategoryAttribute Fileds CategoryAttributeID CategoryID Name DisplayOrder Table 3 -- CategoryAttributeOptions Fileds CategoryAttributeoptionsID CategoryID Name DisplayOrder How i insert data from categoryattribute table to catgory table How i insert data from categoryattributeoptions table to catgoryattribute table LINQ is very confussing I can understand how to insert data with Foreign keys and primary key Help me
-
Hello all I have three tables First 1 -------------------- with These Fileds CREATE TABLE [dbo].[Category]( [CategoryID] [int] IDENTITY(1,1) NOT NULL, [Name] [nvarchar](400) NOT NULL, [Description] [nvarchar](max) NOT NULL, [TemplateID] [int] NOT NULL, [MetaKeywords] [nvarchar](400) NOT NULL, [MetaDescription] [nvarchar](4000) NOT NULL, [MetaTitle] [nvarchar](400) NOT NULL, [SEName] [nvarchar](100) NOT NULL, [ParentCategoryID] [int] NOT NULL, [PictureID] [int] NOT NULL, [PageSize] [int] NOT NULL CONSTRAINT [DF_Nop_Category_PageSize] DEFAULT ((10)), [PriceRanges] [nvarchar](400) NOT NULL CONSTRAINT [DF_Nop_Category_PriceRanges] DEFAULT (''), [ShowOnHomePage] [bit] NOT NULL CONSTRAINT [DF_Nop_Category_ShowOnHomePage] DEFAULT ((0)), [Published] [bit] NOT NULL, [Deleted] [bit] NOT NULL, [DisplayOrder] [int] NOT NULL, [CreatedOn] [datetime] NOT NULL, [UpdatedOn] [datetime] NOT NULL, Table 2 -- CategoryAttribute Fileds CategoryAttributeID CategoryID Name DisplayOrder Table 3 -- CategoryAttributeOptions Fileds CategoryAttributeoptionsID CategoryID Name DisplayOrder How i insert data from categoryattribute table to catgory table How i insert data from categoryattributeoptions table to catgoryattribute table LINQ is very confussing I can understand how to insert data with Foreign keys and primary key Help me
asp_victim wrote:
I can understand how to insert data with Foreign keys and primary key
Then what is your problem?
I know the language. I've read a book. - _Madmatt