public static class ContactQueries { public static string AllContact => "SELECT * FROM [Contact] (NOLOCK)"; public static string ContactById => "SELECT * FROM [Contact] (NOLOCK) WHERE [ContactId] = @ContactId"; public static string AddContact => @"INSERT INTO [Contact] ([FirstName], [LastName], [Email], [PhoneNumber]) VALUES (@FirstName, @LastName, @Email, @PhoneNumber)"; public static string UpdateContact => @"UPDATE [Contact] SET [FirstName] = @FirstName, [LastName] = @LastName, [Email] = @Email, [PhoneNumber] = @PhoneNumber WHERE [ContactId] = @ContactId"; public static string DeleteContact => "DELETE FROM [Contact] WHERE [ContactId] = @ContactId"; }