How to Display Message on client project which comes from WCF?

Sumit Kumawat

14y2.5k

Hi all,
i am writing Data Base Connectivity method in WCF in which i am cheacking if data exist then It should check that data in in Database or not else insert data in Database.
now if there is already Data inside the data base how can i send msg to client that data is already there.
here is my Wcf code...

public void Insert(string value, string value1, string value2)
{

string select = "Select count(*) from Test where FName = '" + value1 + "' ";

SqLite_con = new SQLiteConnection(@"data source=E:\WCF.s3db;Version=3;New=False;Compress=True;");

SqLite_con.Open();

Sqlite_cmd = new SQLiteCommand(select, SqLite_con);

int count = Convert.ToInt32(Sqlite_cmd.ExecuteScalar());

SqLite_con.Close();

if (count > 0)

{

/// here if data is exist i want to send msg

}

else

{

string Insert = "Insert into RackSpaceDownload (FName,Source_path,Destination_path,Last_modified_date) values ('" + value1 + "','" + SourcePath + "','" + value2 + "','" + FileDate + "')";

SqLite_con = new SQLiteConnection(@"data source=E:\WCF.s3db;Version=3;New=False;Compress=True;");

SqLite_con.Open();

Sqlite_cmd = SqLite_con.CreateCommand();

Sqlite_cmd.CommandText = Insert;

Sqlite_cmd.ExecuteNonQuery();

SqLite_con.Close();

}
}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Senthilkumar14y ago
Accepted answer
Hi Sumit,

You need to throw the message so that the client can catch and show it.

throw new Exception("Custom Exception");

Usually what they used to do, they will create the fault contract in WCF with custom data contract.

[DataContract]
public class OrderFault
{
[DataMember]
public int OrderId { get; set; }

[DataMember]
public string Message { get; set
}

In order to throw Fault to client, we have to specify the expected faults above the method/operation using the FaultContractAttribute as follows:

[OperationContract]
[FaultContract(typeof(OrderFault))]
OrderType GetOrder(int orderId);
In the method definition, throw the Fault as follows:

OrderFault fault = new OrderFault{OrderId = 10, Message="Fault"};
throw new FaultException(fault, "Order Fault");

Now at client side, you have to catch the fault as follows:

catch (FaultException ex)
{
}
Inside catch, you can get the exception details using ex.Detail. In our case, it's OrderFault.

That's it. In this way, you can throw custom error message as fault from WCF service and use in client.

For more info:
http://www.codeproject.com/Articles/294609/Uing-FaultContract-to-throw-custom-error-informati
0
Sumit Kumawat14y ago
Thanx a lott sir. :)
0