How to generate UID for any table?

The object layer auto-generates these values for you.

It was throwing an error when I was trying to insert the data in table via script

You need to post the error message and your code if you want the community to help you out.

Hi Markus,

Here is the code

Public Function testscript() As String

Dim ConnectionString As String = Connection.GetSingleProperty("DialogDatabase", "ConnectionString", "")
Dim con As New SqlConnection
con.ConnectionString = ConnectionString

Dim Querypeset As String = "Insert Into Eset (Ident_Eset,DisplayName,Description) Values('ABC','ABC','description')"

Dim cmdpeset As New SqlCommand(Querypeset, con)

con.Open()
cmdpeset.ExecuteNonQuery()

con.Close

Return "done"
End Function

and the error message

Exception has been thrown by the target of an invocation.
Cannot insert the value NULL into column 'UID_ESet', table 'IDSVCDB.dbo.ESet'; column does not allow nulls. INSERT fails.
The statement has been terminated.

Hi Markus,

Here is the code

Public Function testscript() As String

Dim ConnectionString As String = Connection.GetSingleProperty("DialogDatabase", "ConnectionString", "")
Dim con As New SqlConnection
con.ConnectionString = ConnectionString

Dim Querypeset As String = "Insert Into Eset (Ident_Eset,DisplayName,Description) Values('ABC','ABC','description')"

Dim cmdpeset As New SqlCommand(Querypeset, con)

con.Open()
cmdpeset.ExecuteNonQuery()

con.Close

Return "done"
End Function

and the error message

Exception has been thrown by the target of an invocation.
Cannot insert the value NULL into column 'UID_ESet', table 'IDSVCDB.dbo.ESet'; column does not allow nulls. INSERT fails.
The statement has been terminated.

This one is obvoious.  You are not using the OneIM object layer.  You are using the raw SQL queries.  This is not a best practice.

Thanks, George. I totally agree.