Concat a string with an Id in sql

@Garima 

On ModelCreating is not related to webform or MVC, it is related to EF, so if you are using EF then you must have this method inside DbContext class.

Sachin Singh

I am not working on Asp.net MVC, its a webform project

So there is no OnModelCreating() method in it

You can not make an int column computed varchar , you need to modify the Id column to be a varchar or you need to introduce a new column as

[DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public int Id { get; set; }
        public string? Name { get; set; }
        public int? SId { get; set; }

        public int? PId { get; set; }
        public string? Details { get; set; }

        public int? Documents { get; set; }

        public int? MobileNo { get; set; }

        public bool? IsActive { get; set; }
        public string? Status { get; set; }
       public string AgriID{ get; set; }

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    modelBuilder.Entity
()
    .Property(p => p.AgriID)
    .HasComputedColumnSql("'Agri' +Id");
}

later on use AgriID instead of Id in your project

You can use the CONCAT function in T-SQL to concatenate the 'Id' column with the string 'Agri' to get the desired output. Here's an example:

SELECT CONCAT(Id, 'Agri') AS NewId, Name, SId, PId, Detail, Documents, Mobile_No, IsActive, Status
FROM Details

This will return a new column 'NewId' with the concatenated value of 'Id' and 'Agri', along with the other columns from the 'Details' table. If you want to update the 'Id' column in the table with the new concatenated values, you can use the following UPDATE statement:

UPDATE Details
SET Id = CONCAT(Id, 'Agri')    

This will update the 'Id' column in the 'Details' table with the new concatenated values.

Naimish Makwana

if i create it with model then how

[DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public int Id { get; set; }
        public string? Name { get; set; }
        public int? SId { get; set; }

        public int? PId { get; set; }
        public string? Details { get; set; }

        public int? Documents { get; set; }

        public int? MobileNo { get; set; }

        public bool? IsActive { get; set; }
        public string? Status { get; set; }

Hello Garima,

You can use the CONCAT() function to concatenate the string "Agri" with the Id column. Example add new column AgriId  to the table,

CREATE TABLE [dbo].[Details](
    [Id] [int] IDENTITY(1,1) NOT NULL,
    [Name] [nvarchar](max) NULL,
    [SId] [int] NULL,
    [PId] [int] NULL,
    [Detail] [nvarchar](max) NULL,
    [Documents] [int] NULL,
    [Mobile_No] [int] NULL,
    [IsActive] [bit] NULL,
    [Status] [nvarchar](max) NULL,
    [AgriId] AS CONCAT(Id, 'Agri') PERSISTED,
 CONSTRAINT [PK_dbo.GrievanceDetails] 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

 

Thanks

Naimish Makwana