How many methods we can add in WCF Service?

Question

Hi All,

I created one WCF service and i added 160 methods in that service.
In future i have to add more method to this service.

If i add like that any perfomance issue will be there?
How many number of methods we can add in one WCF service?
There is any restriction?

Please help me.

Regards,
Jeevan

Answer 1

        private void cmdSearch_Click(object sender, EventArgs e)
        {
            SqlConnection sqlNWConn = new SqlConnection();
            SqlDataAdapter daCustomers;
            DataSet dsCustomers;
            String tableName = "Customers";

            sqlNWConn = new SqlConnection(@"Data Source=DANS-MAC--WIN7\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=True");

                    if (radioAll.Checked == true)
                    {
                        try
                        {
                            sqlNWConn.Open();
                            dsCustomers = new DataSet();                                                // Creates a new DataSet
                            daCustomers = new SqlDataAdapter("select * from Customers", sqlNWConn);     // Creates a new SqlDataAdapter with select command and connection
                            SqlCommandBuilder cmdBldr = new SqlCommandBuilder(daCustomers);             // Fills in insert, update, and delete commands
                            daCustomers.Fill(dsCustomers, tableName);                                   // Fills the dataset
                            dataGridCustomers.DataSource = dsCustomers;
                            dataGridCustomers.DataMember = tableName;
                        }
                        catch
                        {
                            MessageBox.Show("there was an error and your code is crap"); // error will be changed when working
                        }
                    }

                    if (radioName.Checked == true)
                    {
                          // Searches value in txtSearch in table Customer ContactName
                    }
          }

Answer 2

You seem to be feeling panicked. Have a little fun with Database Table Update in a DataGridView without Writing Code.