Click here to Skip to main content
15,868,016 members
Home / Discussions / Database
   

Database

 
GeneralRe: Sqlserver Pin
jschell2-Dec-11 8:49
jschell2-Dec-11 8:49 
AnswerRe: Sqlserver Pin
thatraja1-Dec-11 22:41
professionalthatraja1-Dec-11 22:41 
JokeRe: Sqlserver Pin
Eddy Vluggen2-Dec-11 7:31
professionalEddy Vluggen2-Dec-11 7:31 
JokeRe: Sqlserver Pin
SilimSayo14-Dec-11 3:25
SilimSayo14-Dec-11 3:25 
JokeRe: Sqlserver Pin
SilimSayo2-Dec-11 9:37
SilimSayo2-Dec-11 9:37 
QuestionSQLite's FAIL ALGORITHM IN ONCONFLICT CLAUSE Pin
Member 83043881-Dec-11 20:16
Member 83043881-Dec-11 20:16 
QuestionDTC crashing SQL server on an update? Pin
devvvy1-Dec-11 18:43
devvvy1-Dec-11 18:43 
QuestionDatabase unable to return data to all clients for 10 clients or more making same call at same time. Pin
Steve Holdorf1-Dec-11 3:22
Steve Holdorf1-Dec-11 3:22 
I have been working on this one for week and I need help. It is complicated but I will try to explain what is going on and show a little code. What I have is a Silverlight application that communicates via WCF to the database. Now, the complicated part is that a windows job sends a UDP alert packet to each of the Silverlight clients to trigger an update of a DataGrid on the main page which does it update via the same WCF service Async call. This means that if I have 50 Silverlight clients when the alert packet is fired each of the 50 clients will make the same WCF call to the database. I have checked and insured that each client receives the UDP call. The problem is that when the clients all make the same call It gives me a wcf service error on some, but not all, of the clients. The code below shows the basic concept of the code in WCF service database call and Silverlight code. Of course the code is broken up into several sections, but you should get the main idea.



(WCF CODE)



List<customer> clist = new List<customer>();

...

_sqlcommand = new SQLCommand();



_sqlcommand = new SQLCommand();

_sqlcommand.Connection = _database.connectionString;

_sqlcommand.CommandType = CommandType.StoredProcedure;

_sqlcommand.CommandText=”GetCustomers”;



try

{



Customer customer;



_reader = _sqlcommand.ExecuteReader();



While (_reader.Read())

{



customer = new Customer();



customer.Name = _reader[“Name”].ToString();









clist.Add(customer);

}

}

catch (exception e)

{



}

}

return clist;



(SILVERLIGHT CODE)



observableCollection<customer> obsCollection = new observableCollection<customer>();



private getmethod()

{



current.client.GetCustomerServiceCompleted += new EventHandler(ServiceReference.GetCustomerServiceCompleteEventArgs(client_GetCustomerServiceCompleted);



current.client.GetCustomerServiceAsync();



}



void client_GetCustomerServiceCompleted (sender, ServiceReference. GetCustomerServiceCompleteEventArgs e)

{



obsCollection = e.Results;



this.CustomerGrid.ItemsSource = obsCollection;

}



Thank you very much!





Steve Holdorf
AnswerRe: Database unable to return data to all clients for 10 clients or more making same call at same time. Pin
Shameel1-Dec-11 3:56
professionalShameel1-Dec-11 3:56 
GeneralRe: Database unable to return data to all clients for 10 clients or more making same call at same time. Pin
Steve Holdorf1-Dec-11 4:05
Steve Holdorf1-Dec-11 4:05 
AnswerRe: Database unable to return data to all clients for 10 clients or more making same call at same time. Pin
Steve Holdorf1-Dec-11 7:22
Steve Holdorf1-Dec-11 7:22 
QuestionDisplaying Objects within a Date Range Pin
Aptiva Dave30-Nov-11 5:12
Aptiva Dave30-Nov-11 5:12 
AnswerRe: Displaying Objects within a Date Range Pin
Chris Meech30-Nov-11 6:27
Chris Meech30-Nov-11 6:27 
AnswerRe: Displaying Objects within a Date Range Pin
jschell30-Nov-11 10:30
jschell30-Nov-11 10:30 
AnswerRe: Displaying Objects within a Date Range Pin
PIEBALDconsult30-Nov-11 14:59
mvePIEBALDconsult30-Nov-11 14:59 
AnswerRe: Displaying Objects within a Date Range Pin
Mycroft Holmes30-Nov-11 16:57
professionalMycroft Holmes30-Nov-11 16:57 
Questioncompare two SQL database Pin
jojoba201130-Nov-11 0:28
jojoba201130-Nov-11 0:28 
AnswerRe: compare two SQL database Pin
R. Giskard Reventlov30-Nov-11 0:57
R. Giskard Reventlov30-Nov-11 0:57 
AnswerRe: compare two SQL database Pin
Mycroft Holmes30-Nov-11 12:06
professionalMycroft Holmes30-Nov-11 12:06 
QuestionRe: compare two SQL database Pin
jojoba201130-Nov-11 17:55
jojoba201130-Nov-11 17:55 
QuestionLEFT OUTER JOIN not working Pin
mjackson1129-Nov-11 7:21
mjackson1129-Nov-11 7:21 
AnswerRe: LEFT OUTER JOIN not working Pin
berba29-Nov-11 7:44
berba29-Nov-11 7:44 
GeneralRe: LEFT OUTER JOIN not working Pin
Chris Meech29-Nov-11 7:50
Chris Meech29-Nov-11 7:50 
AnswerRe: LEFT OUTER JOIN not working Pin
Chris Meech29-Nov-11 7:52
Chris Meech29-Nov-11 7:52 
AnswerRe: LEFT OUTER JOIN not working - SOLVED Pin
mjackson1129-Nov-11 8:04
mjackson1129-Nov-11 8:04 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.