• 02-11-2021, 21:59:14
    #10
    emindiloglu adlı üyeden alıntı: mesajı görüntüle
    Projenin GitHub linkini atar mısın?
    link
  • 02-11-2021, 22:06:20
    #11
    ByQush adlı üyeden alıntı: mesajı görüntüle


    Öncelikle Nuget Package Manager'da aşağıdaki package'ları güncelleyin.
    • Microsoft.CodeDom.Providers.DotNetCompilerPlatform
    • Microsoft.Net.Compilers
    Sonra Sırası ile aşağıdaki adımları uygulayın;
    • Clean All Projects.
    • Unload All Projects.
    • Reload All Projects.
    • ReBuild Solution.
    Projenizde başarılar...



  • 02-11-2021, 22:21:32
    #12
    umutulukurt adlı üyeden alıntı: mesajı görüntüle
    Öncelikle Nuget Package Manager'da aşağıdaki package'ları güncelleyin.
    • Microsoft.CodeDom.Providers.DotNetCompilerPlatform
    • Microsoft.Net.Compilers
    Sonra Sırası ile aşağıdaki adımları uygulayın;
    • Clean All Projects.
    • Unload All Projects.
    • Reload All Projects.
    • ReBuild Solution.
    Projenizde başarılar...



    Hocam uyguladım bu adımları son hali;
  • 02-11-2021, 23:18:53
    #13
    ByQush adlı üyeden alıntı: mesajı görüntüle
    Hocam uyguladım bu adımları son hali;
    Farklı nedenleri olabilir.
    Örneğin projede var olan bazı Nuget paketleri bulunamamıştır ya da hedef framework farklıdır. Proje gereksinimi 4.6.1 dir ama sizde yüklü değildir vb gibi.
    Bunları denemelisiniz.

    İyi çalışmalar
  • 05-11-2021, 16:56:24
    #14
    Kimlik doğrulama veya yönetimden onay bekliyor.
    Yapman gereken basit PostSharp kur projeyi temizle fluettenlerin kullanım dışı olanlarını kaldır sonra visual studio tekrar aç kapat sonrasında dadam sorunsuz devam et...



    Derlenmiş Hali database ayar vs yapmadım gerekte yok
  • 05-11-2021, 17:29:42
    #15
    Üyeliği durduruldu
    ByQush adlı üyeden alıntı: mesajı görüntüle
    Arkadaşlar Githubda yayınlanan mvc projesini inceliyebilmek için çalıştırmam gerekli ama bir türlü çalıştıramadım.
    bağlanıp yardımcı olabilecek arkadaş varsa hayır duamı alır.
    projenin github linkini atar mısın
  • 05-11-2021, 20:51:46
    #16
    yuKKo adlı üyeden alıntı: mesajı görüntüle
    projenin github linkini atar mısın
    github
  • 06-11-2021, 21:28:42
    #17


    Database sql ise
    -- ----------------------------
    -- Table structure for Categories
    -- ----------------------------
    IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Categories]') AND type IN ('U'))
        DROP TABLE [dbo].[Categories]
    GO
    
    CREATE TABLE [dbo].[Categories] (
      [CategoryID] int  NOT NULL,
      [CategoryName] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Description] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Picture] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Active] varchar(255) COLLATE Turkish_CI_AS  NULL
    )
    GO
    
    ALTER TABLE [dbo].[Categories] SET (LOCK_ESCALATION = TABLE)
    GO
    
    
    -- ----------------------------
    -- Table structure for Colors
    -- ----------------------------
    IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Colors]') AND type IN ('U'))
        DROP TABLE [dbo].[Colors]
    GO
    
    CREATE TABLE [dbo].[Colors] (
      [ColorID] int  NOT NULL,
      [Color] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [ColorValue] varchar(255) COLLATE Turkish_CI_AS  NULL
    )
    GO
    
    ALTER TABLE [dbo].[Colors] SET (LOCK_ESCALATION = TABLE)
    GO
    
    
    -- ----------------------------
    -- Records of Colors
    -- ----------------------------
    INSERT INTO [dbo].[Colors]  VALUES (N'1', N'Sarı', NULL)
    GO
    
    
    -- ----------------------------
    -- Table structure for Complaints
    -- ----------------------------
    IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Complaints]') AND type IN ('U'))
        DROP TABLE [dbo].[Complaints]
    GO
    
    CREATE TABLE [dbo].[Complaints] (
      [ComplaintID] int  NOT NULL,
      [Title] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [CustomerID] int  NULL,
      [Description] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [CreatedDate] datetime  NULL
    )
    GO
    
    ALTER TABLE [dbo].[Complaints] SET (LOCK_ESCALATION = TABLE)
    GO
    
    
    -- ----------------------------
    -- Table structure for Customers
    -- ----------------------------
    IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Customers]') AND type IN ('U'))
        DROP TABLE [dbo].[Customers]
    GO
    
    CREATE TABLE [dbo].[Customers] (
      [CustomerID] int  NOT NULL,
      [FirstName] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [LastName] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Address1] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Address2] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [City] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [PostalCode] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Country] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Phone] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Email] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Password] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [CreditCard] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [CardExpMo] int  NULL,
      [CardExpYr] int  NULL,
      [CreditCardTypeID] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [BillingAddress] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [BillingCity] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [BillingCountry] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [BillingPostalCode] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [ShipAddress] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [ShipCity] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [ShipPostalCode] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [ShipCountry] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [RegistrationDate] datetime  NULL,
      [RoleId] int  NULL
    )
    GO
    
    ALTER TABLE [dbo].[Customers] SET (LOCK_ESCALATION = TABLE)
    GO
    
    
    -- ----------------------------
    -- Table structure for OrderDetails
    -- ----------------------------
    IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[OrderDetails]') AND type IN ('U'))
        DROP TABLE [dbo].[OrderDetails]
    GO
    
    CREATE TABLE [dbo].[OrderDetails] (
      [OrderDetailID] int  NOT NULL,
      [ProductID] int  NULL,
      [OrderID] int  NULL,
      [OrderNumber] bigint  NULL,
      [Price] int  NULL,
      [Quantity] int  NULL,
      [Discount] int  NULL,
      [Total] int  NULL,
      [Size] nvarchar(1) COLLATE Turkish_CI_AS  NULL,
      [Color] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [FulFilled] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [ShipDate] datetime2(7)  NULL,
      [BillDate] datetime2(7)  NULL
    )
    GO
    
    ALTER TABLE [dbo].[OrderDetails] SET (LOCK_ESCALATION = TABLE)
    GO
    
    
    -- ----------------------------
    -- Table structure for Orders
    -- ----------------------------
    IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Orders]') AND type IN ('U'))
        DROP TABLE [dbo].[Orders]
    GO
    
    CREATE TABLE [dbo].[Orders] (
      [OrderID] int  NOT NULL,
      [CustomerID] int  NULL,
      [PaymentID] int  NULL,
      [OrderNumber] bigint  NULL,
      [OrderDate] datetime  NULL,
      [ShipDate] datetime  NULL,
      [ShipperID] int  NULL,
      [Freight] money  NULL,
      [SalesTax] money  NULL,
      [FulFilled] bit  NULL,
      [Deleted] bit  NULL,
      [PaymentDate] datetime  NULL,
      [Paid] money  NULL,
      [TransactStatus] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [ErrLoc] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [ErrMsg] varchar(255) COLLATE Turkish_CI_AS  NULL
    )
    GO
    
    ALTER TABLE [dbo].[Orders] SET (LOCK_ESCALATION = TABLE)
    GO
    
    
    -- ----------------------------
    -- Table structure for Payments
    -- ----------------------------
    IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Payments]') AND type IN ('U'))
        DROP TABLE [dbo].[Payments]
    GO
    
    CREATE TABLE [dbo].[Payments] (
      [PaymentID] int  NOT NULL,
      [PaymentType] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Allowed] bit  NULL
    )
    GO
    
    ALTER TABLE [dbo].[Payments] SET (LOCK_ESCALATION = TABLE)
    GO
    
    
    -- ----------------------------
    -- Table structure for Products
    -- ----------------------------
    IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Products]') AND type IN ('U'))
        DROP TABLE [dbo].[Products]
    GO
    
    CREATE TABLE [dbo].[Products] (
      [ProductID] int  NOT NULL,
      [ProductName] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [ProductDescription] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [SupplierID] int  NULL,
      [CategoryID] int  NULL,
      [QuantityPerUnit] int  NULL,
      [UnitPrice] int  NULL,
      [SizeID] int  NOT NULL,
      [ColorID] int  NOT NULL,
      [Discount] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Picture] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [DiscountAvailable] bit  NULL,
      [CurrentOrder] bit  NULL
    )
    GO
    
    ALTER TABLE [dbo].[Products] SET (LOCK_ESCALATION = TABLE)
    GO
    
    
    -- ----------------------------
    -- Table structure for Roles
    -- ----------------------------
    IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Roles]') AND type IN ('U'))
        DROP TABLE [dbo].[Roles]
    GO
    
    CREATE TABLE [dbo].[Roles] (
      [Id] int  NOT NULL,
      [RoleName] varchar(255) COLLATE Turkish_CI_AS  NULL
    )
    GO
    
    ALTER TABLE [dbo].[Roles] SET (LOCK_ESCALATION = TABLE)
    GO
    
    
    -- ----------------------------
    -- Table structure for Shippers
    -- ----------------------------
    IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Shippers]') AND type IN ('U'))
        DROP TABLE [dbo].[Shippers]
    GO
    
    CREATE TABLE [dbo].[Shippers] (
      [ShipperID] int  NOT NULL,
      [CompanyName] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Phone] varchar(255) COLLATE Turkish_CI_AS  NULL
    )
    GO
    
    ALTER TABLE [dbo].[Shippers] SET (LOCK_ESCALATION = TABLE)
    GO
    
    
    -- ----------------------------
    -- Table structure for Sizes
    -- ----------------------------
    IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Sizes]') AND type IN ('U'))
        DROP TABLE [dbo].[Sizes]
    GO
    
    CREATE TABLE [dbo].[Sizes] (
      [SizeID] int  NOT NULL,
      [Size] nvarchar(1) COLLATE Turkish_CI_AS  NULL,
      [SizeValue] float(53)  NULL
    )
    GO
    
    ALTER TABLE [dbo].[Sizes] SET (LOCK_ESCALATION = TABLE)
    GO
    
    
    -- ----------------------------
    -- Records of Sizes
    -- ----------------------------
    INSERT INTO [dbo].[Sizes]  VALUES (N'1', N'M', NULL)
    GO
    
    
    -- ----------------------------
    -- Table structure for Suppliers
    -- ----------------------------
    IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Suppliers]') AND type IN ('U'))
        DROP TABLE [dbo].[Suppliers]
    GO
    
    CREATE TABLE [dbo].[Suppliers] (
      [SupplierID] int  NOT NULL,
      [CompanyName] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [ContactFName] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [ContactLName] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Address1] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Address2] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [City] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [PostalCode] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Country] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Phone] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Fax] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Email] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Website] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [DiscountType] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [DiscountRate] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [DiscountAvailable] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [CustomerID] int  NULL,
      [Logo] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Note] varchar(255) COLLATE Turkish_CI_AS  NULL
    )
    GO
    
    ALTER TABLE [dbo].[Suppliers] SET (LOCK_ESCALATION = TABLE)
    GO
    
    
    -- ----------------------------
    -- Primary Key structure for table Categories
    -- ----------------------------
    ALTER TABLE [dbo].[Categories] ADD CONSTRAINT [PK__Categori__19093A2BDC670CE3] PRIMARY KEY CLUSTERED ([CategoryID])
    WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
    ON [PRIMARY]
    GO
    
    
    -- ----------------------------
    -- Primary Key structure for table Colors
    -- ----------------------------
    ALTER TABLE [dbo].[Colors] ADD CONSTRAINT [PK__Colors__8DA7676D51CA1D4C] PRIMARY KEY CLUSTERED ([ColorID])
    WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
    ON [PRIMARY]
    GO
    
    
    -- ----------------------------
    -- Primary Key structure for table Complaints
    -- ----------------------------
    ALTER TABLE [dbo].[Complaints] ADD CONSTRAINT [PK__Complain__740D89AF2732EF1E] PRIMARY KEY CLUSTERED ([ComplaintID])
    WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
    ON [PRIMARY]
    GO
    
    
    -- ----------------------------
    -- Primary Key structure for table Customers
    -- ----------------------------
    ALTER TABLE [dbo].[Customers] ADD CONSTRAINT [PK__Customer__A4AE64B8ECDF0326] PRIMARY KEY CLUSTERED ([CustomerID])
    WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
    ON [PRIMARY]
    GO
    
    
    -- ----------------------------
    -- Primary Key structure for table OrderDetails
    -- ----------------------------
    ALTER TABLE [dbo].[OrderDetails] ADD CONSTRAINT [PK__OrderDet__D3B9D30C23587F26] PRIMARY KEY CLUSTERED ([OrderDetailID])
    WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
    ON [PRIMARY]
    GO
    
    
    -- ----------------------------
    -- Primary Key structure for table Orders
    -- ----------------------------
    ALTER TABLE [dbo].[Orders] ADD CONSTRAINT [PK__Orders__C3905BAFD05C1018] PRIMARY KEY CLUSTERED ([OrderID])
    WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
    ON [PRIMARY]
    GO
    
    
    -- ----------------------------
    -- Primary Key structure for table Payments
    -- ----------------------------
    ALTER TABLE [dbo].[Payments] ADD CONSTRAINT [PK__Payments__9B556A58BD67DE30] PRIMARY KEY CLUSTERED ([PaymentID])
    WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
    ON [PRIMARY]
    GO
    
    
    -- ----------------------------
    -- Primary Key structure for table Products
    -- ----------------------------
    ALTER TABLE [dbo].[Products] ADD CONSTRAINT [PK__Products__B40CC6EDD66B4F64] PRIMARY KEY CLUSTERED ([ProductID])
    WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
    ON [PRIMARY]
    GO
    
    
    -- ----------------------------
    -- Primary Key structure for table Roles
    -- ----------------------------
    ALTER TABLE [dbo].[Roles] ADD CONSTRAINT [PK__Roles__3214EC0792FBB6BE] PRIMARY KEY CLUSTERED ([Id])
    WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
    ON [PRIMARY]
    GO
    
    
    -- ----------------------------
    -- Primary Key structure for table Shippers
    -- ----------------------------
    ALTER TABLE [dbo].[Shippers] ADD CONSTRAINT [PK__Shippers__1F8AFFB93B884D8C] PRIMARY KEY CLUSTERED ([ShipperID])
    WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
    ON [PRIMARY]
    GO
    
    
    -- ----------------------------
    -- Primary Key structure for table Sizes
    -- ----------------------------
    ALTER TABLE [dbo].[Sizes] ADD CONSTRAINT [PK__Sizes__83BD095A492BC076] PRIMARY KEY CLUSTERED ([SizeID])
    WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
    ON [PRIMARY]
    GO
    
    
    -- ----------------------------
    -- Primary Key structure for table Suppliers
    -- ----------------------------
    ALTER TABLE [dbo].[Suppliers] ADD CONSTRAINT [PK__Supplier__4BE66694FD53D5D6] PRIMARY KEY CLUSTERED ([SupplierID])
    WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
    ON [PRIMARY]
    GO
    
    
    -- ----------------------------
    -- Foreign Keys structure for table Complaints
    -- ----------------------------
    ALTER TABLE [dbo].[Complaints] ADD CONSTRAINT [fk_Complaints_Customers_1] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[Customers] ([CustomerID]) ON DELETE NO ACTION ON UPDATE NO ACTION
    GO
    
    
    -- ----------------------------
    -- Foreign Keys structure for table OrderDetails
    -- ----------------------------
    ALTER TABLE [dbo].[OrderDetails] ADD CONSTRAINT [fk_OrderDetails_Products_1] FOREIGN KEY ([ProductID]) REFERENCES [dbo].[Products] ([ProductID]) ON DELETE NO ACTION ON UPDATE NO ACTION
    GO
    
    ALTER TABLE [dbo].[OrderDetails] ADD CONSTRAINT [fk_OrderDetails_Orders_1] FOREIGN KEY ([OrderID]) REFERENCES [dbo].[Orders] ([OrderID]) ON DELETE NO ACTION ON UPDATE NO ACTION
    GO
    
    
    -- ----------------------------
    -- Foreign Keys structure for table Orders
    -- ----------------------------
    ALTER TABLE [dbo].[Orders] ADD CONSTRAINT [fk_Orders_Customers_1] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[Customers] ([CustomerID]) ON DELETE NO ACTION ON UPDATE NO ACTION
    GO
    
    ALTER TABLE [dbo].[Orders] ADD CONSTRAINT [fk_Orders_Payments_1] FOREIGN KEY ([PaymentID]) REFERENCES [dbo].[Payments] ([PaymentID]) ON DELETE NO ACTION ON UPDATE NO ACTION
    GO
    
    
    -- ----------------------------
    -- Foreign Keys structure for table Products
    -- ----------------------------
    ALTER TABLE [dbo].[Products] ADD CONSTRAINT [fk_Products_Categories_1] FOREIGN KEY ([CategoryID]) REFERENCES [dbo].[Categories] ([CategoryID]) ON DELETE NO ACTION ON UPDATE NO ACTION
    GO
    
    ALTER TABLE [dbo].[Products] ADD CONSTRAINT [fk_Products_Suppliers_1] FOREIGN KEY ([SupplierID]) REFERENCES [dbo].[Suppliers] ([SupplierID]) ON DELETE NO ACTION ON UPDATE NO ACTION
    GO
    
    ALTER TABLE [dbo].[Products] ADD CONSTRAINT [fk_Products_Sizes_1] FOREIGN KEY ([SizeID]) REFERENCES [dbo].[Sizes] ([SizeID]) ON DELETE NO ACTION ON UPDATE NO ACTION
    GO
    
    ALTER TABLE [dbo].[Products] ADD CONSTRAINT [fk_Products_Colors_1] FOREIGN KEY ([ColorID]) REFERENCES [dbo].[Colors] ([ColorID]) ON DELETE NO ACTION ON UPDATE NO ACTION
    GO
    
    ALTER TABLE [dbo].[Products] ADD CONSTRAINT [fk_Products_Suppliers_2] FOREIGN KEY ([SupplierID]) REFERENCES [dbo].[Suppliers] ([SupplierID]) ON DELETE NO ACTION ON UPDATE NO ACTION
    GO
    Sadece yapman gereken otomatik id artımını açmayı unuttum onuda sen yaparsın artık...
  • 06-11-2021, 22:23:00
    #18
    uzeyiray06 adlı üyeden alıntı: mesajı görüntüle


    Database sql ise
    -- ----------------------------
    -- Table structure for Categories
    -- ----------------------------
    IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Categories]') AND type IN ('U'))
        DROP TABLE [dbo].[Categories]
    GO
    
    CREATE TABLE [dbo].[Categories] (
      [CategoryID] int  NOT NULL,
      [CategoryName] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Description] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Picture] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Active] varchar(255) COLLATE Turkish_CI_AS  NULL
    )
    GO
    
    ALTER TABLE [dbo].[Categories] SET (LOCK_ESCALATION = TABLE)
    GO
    
    
    -- ----------------------------
    -- Table structure for Colors
    -- ----------------------------
    IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Colors]') AND type IN ('U'))
        DROP TABLE [dbo].[Colors]
    GO
    
    CREATE TABLE [dbo].[Colors] (
      [ColorID] int  NOT NULL,
      [Color] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [ColorValue] varchar(255) COLLATE Turkish_CI_AS  NULL
    )
    GO
    
    ALTER TABLE [dbo].[Colors] SET (LOCK_ESCALATION = TABLE)
    GO
    
    
    -- ----------------------------
    -- Records of Colors
    -- ----------------------------
    INSERT INTO [dbo].[Colors]  VALUES (N'1', N'Sarı', NULL)
    GO
    
    
    -- ----------------------------
    -- Table structure for Complaints
    -- ----------------------------
    IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Complaints]') AND type IN ('U'))
        DROP TABLE [dbo].[Complaints]
    GO
    
    CREATE TABLE [dbo].[Complaints] (
      [ComplaintID] int  NOT NULL,
      [Title] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [CustomerID] int  NULL,
      [Description] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [CreatedDate] datetime  NULL
    )
    GO
    
    ALTER TABLE [dbo].[Complaints] SET (LOCK_ESCALATION = TABLE)
    GO
    
    
    -- ----------------------------
    -- Table structure for Customers
    -- ----------------------------
    IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Customers]') AND type IN ('U'))
        DROP TABLE [dbo].[Customers]
    GO
    
    CREATE TABLE [dbo].[Customers] (
      [CustomerID] int  NOT NULL,
      [FirstName] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [LastName] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Address1] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Address2] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [City] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [PostalCode] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Country] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Phone] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Email] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Password] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [CreditCard] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [CardExpMo] int  NULL,
      [CardExpYr] int  NULL,
      [CreditCardTypeID] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [BillingAddress] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [BillingCity] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [BillingCountry] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [BillingPostalCode] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [ShipAddress] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [ShipCity] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [ShipPostalCode] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [ShipCountry] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [RegistrationDate] datetime  NULL,
      [RoleId] int  NULL
    )
    GO
    
    ALTER TABLE [dbo].[Customers] SET (LOCK_ESCALATION = TABLE)
    GO
    
    
    -- ----------------------------
    -- Table structure for OrderDetails
    -- ----------------------------
    IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[OrderDetails]') AND type IN ('U'))
        DROP TABLE [dbo].[OrderDetails]
    GO
    
    CREATE TABLE [dbo].[OrderDetails] (
      [OrderDetailID] int  NOT NULL,
      [ProductID] int  NULL,
      [OrderID] int  NULL,
      [OrderNumber] bigint  NULL,
      [Price] int  NULL,
      [Quantity] int  NULL,
      [Discount] int  NULL,
      [Total] int  NULL,
      [Size] nvarchar(1) COLLATE Turkish_CI_AS  NULL,
      [Color] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [FulFilled] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [ShipDate] datetime2(7)  NULL,
      [BillDate] datetime2(7)  NULL
    )
    GO
    
    ALTER TABLE [dbo].[OrderDetails] SET (LOCK_ESCALATION = TABLE)
    GO
    
    
    -- ----------------------------
    -- Table structure for Orders
    -- ----------------------------
    IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Orders]') AND type IN ('U'))
        DROP TABLE [dbo].[Orders]
    GO
    
    CREATE TABLE [dbo].[Orders] (
      [OrderID] int  NOT NULL,
      [CustomerID] int  NULL,
      [PaymentID] int  NULL,
      [OrderNumber] bigint  NULL,
      [OrderDate] datetime  NULL,
      [ShipDate] datetime  NULL,
      [ShipperID] int  NULL,
      [Freight] money  NULL,
      [SalesTax] money  NULL,
      [FulFilled] bit  NULL,
      [Deleted] bit  NULL,
      [PaymentDate] datetime  NULL,
      [Paid] money  NULL,
      [TransactStatus] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [ErrLoc] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [ErrMsg] varchar(255) COLLATE Turkish_CI_AS  NULL
    )
    GO
    
    ALTER TABLE [dbo].[Orders] SET (LOCK_ESCALATION = TABLE)
    GO
    
    
    -- ----------------------------
    -- Table structure for Payments
    -- ----------------------------
    IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Payments]') AND type IN ('U'))
        DROP TABLE [dbo].[Payments]
    GO
    
    CREATE TABLE [dbo].[Payments] (
      [PaymentID] int  NOT NULL,
      [PaymentType] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Allowed] bit  NULL
    )
    GO
    
    ALTER TABLE [dbo].[Payments] SET (LOCK_ESCALATION = TABLE)
    GO
    
    
    -- ----------------------------
    -- Table structure for Products
    -- ----------------------------
    IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Products]') AND type IN ('U'))
        DROP TABLE [dbo].[Products]
    GO
    
    CREATE TABLE [dbo].[Products] (
      [ProductID] int  NOT NULL,
      [ProductName] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [ProductDescription] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [SupplierID] int  NULL,
      [CategoryID] int  NULL,
      [QuantityPerUnit] int  NULL,
      [UnitPrice] int  NULL,
      [SizeID] int  NOT NULL,
      [ColorID] int  NOT NULL,
      [Discount] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Picture] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [DiscountAvailable] bit  NULL,
      [CurrentOrder] bit  NULL
    )
    GO
    
    ALTER TABLE [dbo].[Products] SET (LOCK_ESCALATION = TABLE)
    GO
    
    
    -- ----------------------------
    -- Table structure for Roles
    -- ----------------------------
    IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Roles]') AND type IN ('U'))
        DROP TABLE [dbo].[Roles]
    GO
    
    CREATE TABLE [dbo].[Roles] (
      [Id] int  NOT NULL,
      [RoleName] varchar(255) COLLATE Turkish_CI_AS  NULL
    )
    GO
    
    ALTER TABLE [dbo].[Roles] SET (LOCK_ESCALATION = TABLE)
    GO
    
    
    -- ----------------------------
    -- Table structure for Shippers
    -- ----------------------------
    IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Shippers]') AND type IN ('U'))
        DROP TABLE [dbo].[Shippers]
    GO
    
    CREATE TABLE [dbo].[Shippers] (
      [ShipperID] int  NOT NULL,
      [CompanyName] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Phone] varchar(255) COLLATE Turkish_CI_AS  NULL
    )
    GO
    
    ALTER TABLE [dbo].[Shippers] SET (LOCK_ESCALATION = TABLE)
    GO
    
    
    -- ----------------------------
    -- Table structure for Sizes
    -- ----------------------------
    IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Sizes]') AND type IN ('U'))
        DROP TABLE [dbo].[Sizes]
    GO
    
    CREATE TABLE [dbo].[Sizes] (
      [SizeID] int  NOT NULL,
      [Size] nvarchar(1) COLLATE Turkish_CI_AS  NULL,
      [SizeValue] float(53)  NULL
    )
    GO
    
    ALTER TABLE [dbo].[Sizes] SET (LOCK_ESCALATION = TABLE)
    GO
    
    
    -- ----------------------------
    -- Records of Sizes
    -- ----------------------------
    INSERT INTO [dbo].[Sizes]  VALUES (N'1', N'M', NULL)
    GO
    
    
    -- ----------------------------
    -- Table structure for Suppliers
    -- ----------------------------
    IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Suppliers]') AND type IN ('U'))
        DROP TABLE [dbo].[Suppliers]
    GO
    
    CREATE TABLE [dbo].[Suppliers] (
      [SupplierID] int  NOT NULL,
      [CompanyName] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [ContactFName] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [ContactLName] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Address1] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Address2] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [City] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [PostalCode] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Country] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Phone] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Fax] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Email] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Website] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [DiscountType] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [DiscountRate] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [DiscountAvailable] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [CustomerID] int  NULL,
      [Logo] varchar(255) COLLATE Turkish_CI_AS  NULL,
      [Note] varchar(255) COLLATE Turkish_CI_AS  NULL
    )
    GO
    
    ALTER TABLE [dbo].[Suppliers] SET (LOCK_ESCALATION = TABLE)
    GO
    
    
    -- ----------------------------
    -- Primary Key structure for table Categories
    -- ----------------------------
    ALTER TABLE [dbo].[Categories] ADD CONSTRAINT [PK__Categori__19093A2BDC670CE3] PRIMARY KEY CLUSTERED ([CategoryID])
    WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
    ON [PRIMARY]
    GO
    
    
    -- ----------------------------
    -- Primary Key structure for table Colors
    -- ----------------------------
    ALTER TABLE [dbo].[Colors] ADD CONSTRAINT [PK__Colors__8DA7676D51CA1D4C] PRIMARY KEY CLUSTERED ([ColorID])
    WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
    ON [PRIMARY]
    GO
    
    
    -- ----------------------------
    -- Primary Key structure for table Complaints
    -- ----------------------------
    ALTER TABLE [dbo].[Complaints] ADD CONSTRAINT [PK__Complain__740D89AF2732EF1E] PRIMARY KEY CLUSTERED ([ComplaintID])
    WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
    ON [PRIMARY]
    GO
    
    
    -- ----------------------------
    -- Primary Key structure for table Customers
    -- ----------------------------
    ALTER TABLE [dbo].[Customers] ADD CONSTRAINT [PK__Customer__A4AE64B8ECDF0326] PRIMARY KEY CLUSTERED ([CustomerID])
    WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
    ON [PRIMARY]
    GO
    
    
    -- ----------------------------
    -- Primary Key structure for table OrderDetails
    -- ----------------------------
    ALTER TABLE [dbo].[OrderDetails] ADD CONSTRAINT [PK__OrderDet__D3B9D30C23587F26] PRIMARY KEY CLUSTERED ([OrderDetailID])
    WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
    ON [PRIMARY]
    GO
    
    
    -- ----------------------------
    -- Primary Key structure for table Orders
    -- ----------------------------
    ALTER TABLE [dbo].[Orders] ADD CONSTRAINT [PK__Orders__C3905BAFD05C1018] PRIMARY KEY CLUSTERED ([OrderID])
    WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
    ON [PRIMARY]
    GO
    
    
    -- ----------------------------
    -- Primary Key structure for table Payments
    -- ----------------------------
    ALTER TABLE [dbo].[Payments] ADD CONSTRAINT [PK__Payments__9B556A58BD67DE30] PRIMARY KEY CLUSTERED ([PaymentID])
    WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
    ON [PRIMARY]
    GO
    
    
    -- ----------------------------
    -- Primary Key structure for table Products
    -- ----------------------------
    ALTER TABLE [dbo].[Products] ADD CONSTRAINT [PK__Products__B40CC6EDD66B4F64] PRIMARY KEY CLUSTERED ([ProductID])
    WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
    ON [PRIMARY]
    GO
    
    
    -- ----------------------------
    -- Primary Key structure for table Roles
    -- ----------------------------
    ALTER TABLE [dbo].[Roles] ADD CONSTRAINT [PK__Roles__3214EC0792FBB6BE] PRIMARY KEY CLUSTERED ([Id])
    WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
    ON [PRIMARY]
    GO
    
    
    -- ----------------------------
    -- Primary Key structure for table Shippers
    -- ----------------------------
    ALTER TABLE [dbo].[Shippers] ADD CONSTRAINT [PK__Shippers__1F8AFFB93B884D8C] PRIMARY KEY CLUSTERED ([ShipperID])
    WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
    ON [PRIMARY]
    GO
    
    
    -- ----------------------------
    -- Primary Key structure for table Sizes
    -- ----------------------------
    ALTER TABLE [dbo].[Sizes] ADD CONSTRAINT [PK__Sizes__83BD095A492BC076] PRIMARY KEY CLUSTERED ([SizeID])
    WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
    ON [PRIMARY]
    GO
    
    
    -- ----------------------------
    -- Primary Key structure for table Suppliers
    -- ----------------------------
    ALTER TABLE [dbo].[Suppliers] ADD CONSTRAINT [PK__Supplier__4BE66694FD53D5D6] PRIMARY KEY CLUSTERED ([SupplierID])
    WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
    ON [PRIMARY]
    GO
    
    
    -- ----------------------------
    -- Foreign Keys structure for table Complaints
    -- ----------------------------
    ALTER TABLE [dbo].[Complaints] ADD CONSTRAINT [fk_Complaints_Customers_1] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[Customers] ([CustomerID]) ON DELETE NO ACTION ON UPDATE NO ACTION
    GO
    
    
    -- ----------------------------
    -- Foreign Keys structure for table OrderDetails
    -- ----------------------------
    ALTER TABLE [dbo].[OrderDetails] ADD CONSTRAINT [fk_OrderDetails_Products_1] FOREIGN KEY ([ProductID]) REFERENCES [dbo].[Products] ([ProductID]) ON DELETE NO ACTION ON UPDATE NO ACTION
    GO
    
    ALTER TABLE [dbo].[OrderDetails] ADD CONSTRAINT [fk_OrderDetails_Orders_1] FOREIGN KEY ([OrderID]) REFERENCES [dbo].[Orders] ([OrderID]) ON DELETE NO ACTION ON UPDATE NO ACTION
    GO
    
    
    -- ----------------------------
    -- Foreign Keys structure for table Orders
    -- ----------------------------
    ALTER TABLE [dbo].[Orders] ADD CONSTRAINT [fk_Orders_Customers_1] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[Customers] ([CustomerID]) ON DELETE NO ACTION ON UPDATE NO ACTION
    GO
    
    ALTER TABLE [dbo].[Orders] ADD CONSTRAINT [fk_Orders_Payments_1] FOREIGN KEY ([PaymentID]) REFERENCES [dbo].[Payments] ([PaymentID]) ON DELETE NO ACTION ON UPDATE NO ACTION
    GO
    
    
    -- ----------------------------
    -- Foreign Keys structure for table Products
    -- ----------------------------
    ALTER TABLE [dbo].[Products] ADD CONSTRAINT [fk_Products_Categories_1] FOREIGN KEY ([CategoryID]) REFERENCES [dbo].[Categories] ([CategoryID]) ON DELETE NO ACTION ON UPDATE NO ACTION
    GO
    
    ALTER TABLE [dbo].[Products] ADD CONSTRAINT [fk_Products_Suppliers_1] FOREIGN KEY ([SupplierID]) REFERENCES [dbo].[Suppliers] ([SupplierID]) ON DELETE NO ACTION ON UPDATE NO ACTION
    GO
    
    ALTER TABLE [dbo].[Products] ADD CONSTRAINT [fk_Products_Sizes_1] FOREIGN KEY ([SizeID]) REFERENCES [dbo].[Sizes] ([SizeID]) ON DELETE NO ACTION ON UPDATE NO ACTION
    GO
    
    ALTER TABLE [dbo].[Products] ADD CONSTRAINT [fk_Products_Colors_1] FOREIGN KEY ([ColorID]) REFERENCES [dbo].[Colors] ([ColorID]) ON DELETE NO ACTION ON UPDATE NO ACTION
    GO
    
    ALTER TABLE [dbo].[Products] ADD CONSTRAINT [fk_Products_Suppliers_2] FOREIGN KEY ([SupplierID]) REFERENCES [dbo].[Suppliers] ([SupplierID]) ON DELETE NO ACTION ON UPDATE NO ACTION
    GO
    Sadece yapman gereken otomatik id artımını açmayı unuttum onuda sen yaparsın artık...
    Eline sağlık hocam teşekkür ederim.