GETTING ID OF INSERTED ROW

In DB.GetData(select) is executed new SqlDataAdapter(Select, dbConnection).Fill(table)

DataTable table = DB.GetData(@"INSERT INTO [table_name] VALUES(values) SELECT id = SCOPE_IDENTITY()")