[ad_1]
Halo semuanya, Saya mendapat kesalahan saat mencoba memperbarui data dalam database di aplikasi ASP.Net MVC pertama saya dan kesalahannya adalah “
An error occurred while updating the entries. See the InnerException for details.
Jadi tolong bantu saya untuk menyelesaikan masalah saya ini. Berikut kodenya:
SQL
public ActionResult Create() { return View(); } [AcceptVerbs(HttpVerbs.Post)] public ActionResult Create([Bind(Exclude="Id")] Movie movieToCreate) { if (!ModelState.IsValid) return View(); _db.AddToMovies(movieToCreate); _db.SaveChanges(); //Error Line return RedirectToAction(movieToCreate); }
Solusi 1
Jika Anda memiliki properti DateTime di kelas Film, harap inisialisasi dengan DateTime saat ini seperti di bawah ini sebelum menyimpannya
C#
movieToCreate.DateProperty=DateTime.Now; _db.AddToMovies(movieToCreate); _db.SaveChanges();
Semoga ini membantu
Solusi 2
silakan periksa semua kolom, ada beberapa kolom yang tidak mengizinkan nol.
Di kolom kasus saya [ID] tidak mengizinkan null, jadi Anda perlu memberi nilai untuk itu.
Solusi 4
SQL
USE [master] GO /****** Object: Database [CepiDev] Script Date: 01-02-2024 21:39:31 ******/ CREATE DATABASE [CepiDev] CONTAINMENT = NONE ON PRIMARY ( NAME = N'CepiDev', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\DATA\CepiDev.mdf' , SIZE = 73728KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB ) LOG ON ( NAME = N'CepiDev_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\DATA\CepiDev_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB ) WITH CATALOG_COLLATION = DATABASE_DEFAULT GO ALTER DATABASE [CepiDev] SET COMPATIBILITY_LEVEL = 150 GO IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) begin EXEC [CepiDev].[dbo].[sp_fulltext_database] @action = 'enable' end GO ALTER DATABASE [CepiDev] SET ANSI_NULL_DEFAULT OFF GO ALTER DATABASE [CepiDev] SET ANSI_NULLS OFF GO ALTER DATABASE [CepiDev] SET ANSI_PADDING OFF GO ALTER DATABASE [CepiDev] SET ANSI_WARNINGS OFF GO ALTER DATABASE [CepiDev] SET ARITHABORT OFF GO ALTER DATABASE [CepiDev] SET AUTO_CLOSE OFF GO ALTER DATABASE [CepiDev] SET AUTO_SHRINK OFF GO ALTER DATABASE [CepiDev] SET AUTO_UPDATE_STATISTICS ON GO ALTER DATABASE [CepiDev] SET CURSOR_CLOSE_ON_COMMIT OFF GO ALTER DATABASE [CepiDev] SET CURSOR_DEFAULT GLOBAL GO ALTER DATABASE [CepiDev] SET CONCAT_NULL_YIELDS_NULL OFF GO ALTER DATABASE [CepiDev] SET NUMERIC_ROUNDABORT OFF GO ALTER DATABASE [CepiDev] SET QUOTED_IDENTIFIER OFF GO ALTER DATABASE [CepiDev] SET RECURSIVE_TRIGGERS OFF GO ALTER DATABASE [CepiDev] SET DISABLE_BROKER GO ALTER DATABASE [CepiDev] SET AUTO_UPDATE_STATISTICS_ASYNC OFF GO ALTER DATABASE [CepiDev] SET DATE_CORRELATION_OPTIMIZATION OFF GO ALTER DATABASE [CepiDev] SET TRUSTWORTHY OFF GO ALTER DATABASE [CepiDev] SET ALLOW_SNAPSHOT_ISOLATION OFF GO ALTER DATABASE [CepiDev] SET PARAMETERIZATION SIMPLE GO ALTER DATABASE [CepiDev] SET READ_COMMITTED_SNAPSHOT OFF GO ALTER DATABASE [CepiDev] SET HONOR_BROKER_PRIORITY OFF GO ALTER DATABASE [CepiDev] SET RECOVERY SIMPLE GO ALTER DATABASE [CepiDev] SET MULTI_USER GO ALTER DATABASE [CepiDev] SET PAGE_VERIFY CHECKSUM GO ALTER DATABASE [CepiDev] SET DB_CHAINING OFF GO ALTER DATABASE [CepiDev] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) GO ALTER DATABASE [CepiDev] SET TARGET_RECOVERY_TIME = 60 SECONDS GO ALTER DATABASE [CepiDev] SET DELAYED_DURABILITY = DISABLED GO ALTER DATABASE [CepiDev] SET ACCELERATED_DATABASE_RECOVERY = OFF GO ALTER DATABASE [CepiDev] SET QUERY_STORE = OFF GO USE [CepiDev] GO /****** Object: Table [dbo].[AspNetRoleClaims] Script Date: 01-02-2024 21:39:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[AspNetRoleClaims]( [Id] [int] IDENTITY(1,1) NOT NULL, [RoleId] [nvarchar](450) NOT NULL, [ClaimType] [nvarchar](max) NULL, [ClaimValue] [nvarchar](max) NULL, CONSTRAINT [PK_AspNetRoleClaims] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[AspNetRoles] Script Date: 01-02-2024 21:39:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[AspNetRoles]( [Id] [nvarchar](450) NOT NULL, [Name] [nvarchar](256) NULL, [NormalizedName] [nvarchar](256) NULL, [ConcurrencyStamp] [nvarchar](max) NULL, CONSTRAINT [PK_AspNetRoles] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[AspNetUserClaims] Script Date: 01-02-2024 21:39:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[AspNetUserClaims]( [Id] [int] IDENTITY(1,1) NOT NULL, [UserId] [nvarchar](450) NOT NULL, [ClaimType] [nvarchar](max) NULL, [ClaimValue] [nvarchar](max) NULL, CONSTRAINT [PK_AspNetUserClaims] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[AspNetUserLogins] Script Date: 01-02-2024 21:39:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[AspNetUserLogins]( [LoginProvider] [nvarchar](450) NOT NULL, [ProviderKey] [nvarchar](450) NOT NULL, [ProviderDisplayName] [nvarchar](max) NULL, [UserId] [nvarchar](450) NOT NULL, CONSTRAINT [PK_AspNetUserLogins] PRIMARY KEY CLUSTERED ( [LoginProvider] ASC, [ProviderKey] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[AspNetUserRoles] Script Date: 01-02-2024 21:39:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[AspNetUserRoles]( [UserId] [nvarchar](450) NOT NULL, [RoleId] [nvarchar](450) NOT NULL, CONSTRAINT [PK_AspNetUserRoles] PRIMARY KEY CLUSTERED ( [UserId] ASC, [RoleId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[AspNetUsers] Script Date: 01-02-2024 21:39:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[AspNetUsers]( [Id] [nvarchar](450) NOT NULL, [UserName] [nvarchar](256) NULL, [NormalizedUserName] [nvarchar](256) NULL, [Email] [nvarchar](256) NULL, [NormalizedEmail] [nvarchar](256) NULL, [EmailConfirmed] [bit] NOT NULL, [PasswordHash] [nvarchar](max) NULL, [SecurityStamp] [nvarchar](max) NULL, [ConcurrencyStamp] [nvarchar](max) NULL, [PhoneNumber] [nvarchar](max) NULL, [PhoneNumberConfirmed] [bit] NOT NULL, [TwoFactorEnabled] [bit] NOT NULL, [LockoutEnd] [datetimeoffset](7) NULL, [LockoutEnabled] [bit] NOT NULL, [AccessFailedCount] [int] NOT NULL, [Discriminator] [nvarchar](max) NOT NULL, [FirstName] [nvarchar](max) NULL, [LastName] [nvarchar](max) NULL, CONSTRAINT [PK_AspNetUsers] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[AspNetUserTokens] Script Date: 01-02-2024 21:39:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[AspNetUserTokens]( [UserId] [nvarchar](450) NOT NULL, [LoginProvider] [nvarchar](450) NOT NULL, [Name] [nvarchar](450) NOT NULL, [Value] [nvarchar](max) NULL, CONSTRAINT [PK_AspNetUserTokens] PRIMARY KEY CLUSTERED ( [UserId] ASC, [LoginProvider] ASC, [Name] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[CowCenter] Script Date: 01-02-2024 21:39:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[CowCenter]( [Id] [int] IDENTITY(1,1) NOT NULL, [Title] [nvarchar](100) NOT NULL, [OrderId] [int] NOT NULL, [Address1] [nvarchar](200) NOT NULL, [Address2] [nvarchar](200) NOT NULL, [City] [nvarchar](100) NOT NULL, [State] [nvarchar](100) NOT NULL, [Zip] [int] NOT NULL, [CreatedDate] [datetime] NOT NULL, [CreatedBy] [nvarchar](100) NOT NULL, [LastModifiedDate] [datetime] NOT NULL, [LastModifiedBy] [nvarchar](100) NOT NULL, CONSTRAINT [PK_CowCenter] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[CowRegistration] Script Date: 01-02-2024 21:39:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[CowRegistration]( [Id] [int] IDENTITY(1,1) NOT NULL, [Title] [nvarchar](100) NOT NULL, [CreatedDate] [datetime] NOT NULL, [CreatedBy] [nvarchar](100) NOT NULL, [LastModifiedDate] [datetime] NOT NULL, [LastModifiedBy] [nvarchar](100) NOT NULL, CONSTRAINT [PK_Register] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Logs] Script Date: 01-02-2024 21:39:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Logs]( [Id] [int] IDENTITY(1,1) NOT NULL, [Message] [nvarchar](max) NULL, [MessageTemplate] [nvarchar](max) NULL, [Level] [nvarchar](max) NULL, [TimeStamp] [datetime] NULL, [Exception] [nvarchar](max) NULL, [Properties] [nvarchar](max) NULL, CONSTRAINT [PK_Logs] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[UserCowCenter] Script Date: 01-02-2024 21:39:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[UserCowCenter]( [Id] [int] IDENTITY(1,1) NOT NULL, [UserId] [nvarchar](450) NOT NULL, [CowCenterId] [int] NOT NULL, CONSTRAINT [PK_UserCowCenter] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO INSERT [dbo].[AspNetRoles] ([Id], [Name], [NormalizedName], [ConcurrencyStamp]) VALUES (N'8b25b46a-0db4-4ca2-8409-71f18c26f2e5', N'Doctor', N'Doctor', NULL) INSERT [dbo].[AspNetRoles] ([Id], [Name], [NormalizedName], [ConcurrencyStamp]) VALUES (N'9f76b7a7-1a34-4318-a57e-3af6b8bd6882', N'Admin', N'Admin', NULL) GO INSERT [dbo].[AspNetUserRoles] ([UserId], [RoleId]) VALUES (N'4552ce6f-5a9f-42d2-a6dd-d0900d395383', N'9f76b7a7-1a34-4318-a57e-3af6b8bd6882') INSERT [dbo].[AspNetUserRoles] ([UserId], [RoleId]) VALUES (N'5daa6fd5-e912-42ec-9a1d-f338b9af5438', N'8b25b46a-0db4-4ca2-8409-71f18c26f2e5') INSERT [dbo].[AspNetUserRoles] ([UserId], [RoleId]) VALUES (N'71dfdb8f-c690-43a9-9789-e9631ec9e6ef', N'8b25b46a-0db4-4ca2-8409-71f18c26f2e5') GO INSERT [dbo].[AspNetUsers] ([Id], [UserName], [NormalizedUserName], [Email], [NormalizedEmail], [EmailConfirmed], [PasswordHash], [SecurityStamp], [ConcurrencyStamp], [PhoneNumber], [PhoneNumberConfirmed], [TwoFactorEnabled], [LockoutEnd], [LockoutEnabled], [AccessFailedCount], [Discriminator], [FirstName], [LastName]) VALUES (N'4552ce6f-5a9f-42d2-a6dd-d0900d395383', N'testadmin@gmail.com', N'TESTADMIN@GMAIL.COM', N'testadmin@gmail.com', N'TESTADMIN@GMAIL.COM', 0, N'AQAAAAEAACcQAAAAENXz5khJ9WkcEdPXL/sh+nb4WngsIZ5513gjsx9z5fYXer+fw2LzgmJmXm5HKz2H4g==', N'2LJ762VYLPU6LNCG6Q2TTP36FTVEBDNV', N'a344c06d-7a85-48d3-8ba1-ac8f2a5000ba', N'0000000000', 0, 0, NULL, 1, 0, N'ApplicationUser', N'Test', N'Admin') INSERT [dbo].[AspNetUsers] ([Id], [UserName], [NormalizedUserName], [Email], [NormalizedEmail], [EmailConfirmed], [PasswordHash], [SecurityStamp], [ConcurrencyStamp], [PhoneNumber], [PhoneNumberConfirmed], [TwoFactorEnabled], [LockoutEnd], [LockoutEnabled], [AccessFailedCount], [Discriminator], [FirstName], [LastName]) VALUES (N'5daa6fd5-e912-42ec-9a1d-f338b9af5438', N'doctor@gmail.com', N'DOCTOR@GMAIL.COM', N'doctor@gmail.com', N'DOCTOR@GMAIL.COM', 0, N'AQAAAAEAACcQAAAAEFHCh+oANgPMnAvPAbPvKHimeDFmdP89zDeCkDvtMMoIuR8KKzNOZhs7BRmC7AGatw==', N'4OUS3VVLU44TOR4NDWL24KICIDS5JG7Y', N'8803738c-e52a-4466-b34a-4716ccc6e914', N'0000000000', 0, 0, NULL, 1, 0, N'ApplicationUser', N'Test', N'doctor') INSERT [dbo].[AspNetUsers] ([Id], [UserName], [NormalizedUserName], [Email], [NormalizedEmail], [EmailConfirmed], [PasswordHash], [SecurityStamp], [ConcurrencyStamp], [PhoneNumber], [PhoneNumberConfirmed], [TwoFactorEnabled], [LockoutEnd], [LockoutEnabled], [AccessFailedCount], [Discriminator], [FirstName], [LastName]) VALUES (N'71dfdb8f-c690-43a9-9789-e9631ec9e6ef', N'doctor1@gmail.com', N'DOCTOR1@GMAIL.COM', N'doctor1@gmail.com', N'DOCTOR1@GMAIL.COM', 0, N'AQAAAAEAACcQAAAAEM/8ItfVDyUiGvTmHNWp3ENjCF6vXzHlSnjqnssmVYpTYvpQIdGCOTZscgyxQxGXdg==', N'YJLNFEJ6TSVKDRT3VAW2QAGNZNDL5PFY', N'e216819c-53ee-4f92-8a75-429c8317b590', N'0000000000', 0, 0, NULL, 1, 0, N'ApplicationUser', N'Test', N'doctor') INSERT [dbo].[AspNetUsers] ([Id], [UserName], [NormalizedUserName], [Email], [NormalizedEmail], [EmailConfirmed], [PasswordHash], [SecurityStamp], [ConcurrencyStamp], [PhoneNumber], [PhoneNumberConfirmed], [TwoFactorEnabled], [LockoutEnd], [LockoutEnabled], [AccessFailedCount], [Discriminator], [FirstName], [LastName]) VALUES (N'f425d5a0-6d2e-4478-92c1-a83888c9e8fc', N'test@test.com', N'TEST@TEST.COM', N'test@test.com', N'TEST@TEST.COM', 0, N'AQAAAAEAACcQAAAAEDM6/R9etaiiD2VltwDvjJ5jbCEHzGpjyne6CnkNNxxHihrAj8V4HREzVz3SnYLG5A==', N'ELC2XSIZ732MENF25XN6A4QWA5WOCDTF', N'6a66dcab-66ec-4e47-89be-6754138f6b9b', N'0000000000', 0, 0, NULL, 1, 0, N'ApplicationUser', N'Test', N'doctor') GO SET IDENTITY_INSERT [dbo].[CowCenter] ON INSERT [dbo].[CowCenter] ([Id], [Title], [OrderId], [Address1], [Address2], [City], [State], [Zip], [CreatedDate], [CreatedBy], [LastModifiedDate], [LastModifiedBy]) VALUES (4, N'Center1', 1, N'test', N'test', N'Hyderabad', N'Telagana', 500019, CAST(N'2024-01-21T20:57:00.597' AS DateTime), N'test', CAST(N'2024-01-21T20:57:00.597' AS DateTime), N'test') SET IDENTITY_INSERT [dbo].[CowCenter] OFF GO SET IDENTITY_INSERT [dbo].[CowRegistration] ON INSERT [dbo].[CowRegistration] ([Id], [Title], [CreatedDate], [CreatedBy], [LastModifiedDate], [LastModifiedBy]) VALUES (2, N'xcvgb', CAST(N'2024-01-15T02:04:26.550' AS DateTime), N'test', CAST(N'2024-01-15T02:04:27.050' AS DateTime), N'test') INSERT [dbo].[CowRegistration] ([Id], [Title], [CreatedDate], [CreatedBy], [LastModifiedDate], [LastModifiedBy]) VALUES (3, N'xcvgb', CAST(N'2024-01-15T02:05:58.277' AS DateTime), N'test', CAST(N'2024-01-15T02:05:58.477' AS DateTime), N'test') INSERT [dbo].[CowRegistration] ([Id], [Title], [CreatedDate], [CreatedBy], [LastModifiedDate], [LastModifiedBy]) VALUES (4, N'xcvgb', CAST(N'2024-01-15T02:06:34.663' AS DateTime), N'test', CAST(N'2024-01-15T02:06:35.113' AS DateTime), N'test') INSERT [dbo].[CowRegistration] ([Id], [Title], [CreatedDate], [CreatedBy], [LastModifiedDate], [LastModifiedBy]) VALUES (5, N'xcvgb', CAST(N'2024-01-15T02:08:08.507' AS DateTime), N'test', CAST(N'2024-01-15T02:08:08.827' AS DateTime), N'test') INSERT [dbo].[CowRegistration] ([Id], [Title], [CreatedDate], [CreatedBy], [LastModifiedDate], [LastModifiedBy]) VALUES (6, N'testsdg', CAST(N'2024-01-15T02:09:39.207' AS DateTime), N'test', CAST(N'2024-01-15T02:09:39.413' AS DateTime), N'test') INSERT [dbo].[CowRegistration] ([Id], [Title], [CreatedDate], [CreatedBy], [LastModifiedDate], [LastModifiedBy]) VALUES (7, N'test cow', CAST(N'2024-02-01T18:58:19.667' AS DateTime), N'testadmin@gmail.com', CAST(N'2024-02-01T18:58:19.667' AS DateTime), N'testadmin@gmail.com') SET IDENTITY_INSERT [dbo].[CowRegistration] OFF GO SET IDENTITY_INSERT [dbo].[Logs] ON
[ad_2]
コメント