how i can invoke C# method when sql trigger is fired ???

Question

how i can invoke or call C# method when sql trigger is fired ??? plz i need help . this is the first time for me here

Kirtan Patel · Answer

Friend your required software is Student Database so its not like enterprise database like huge and its ok to check at Alert Every 10 or 5 min interval as the MailClient Application do ;-) Thank you :)

Kirtan Patel · Answer

thanks dear friend :) its enough for me that you are satisfied with my answer :) Thanks Again :)

abas shahen · Answer

thank u ur 100000000000000% plz if u need any thing just tell me i can help u in any thing u want other than programming because im new. thank u agian and nice to meet u . :)

abas shahen · Answer

hi  thank u alot in fact this is my initial idea  but people tell me its not efficient to check database periodically by timer  it make load on data base  whats ur opinion? its really make load on data base?

Kirtan Patel · Answer

Hi There is Noway you can invoke C# method using SQL Server but try idea like this if tutor Uses C# Desktop application then make also Tutor table For Showing Alert to Him When Student Submit His Assignment at that time Insert Message into TutorTable Like Tutor(StudentId ReadedAlert) here Readed alert is only two value True or False so when tutor Reads That Message in That Window and mark Alert as readed press Ok and that that record's AlertReaded updated in the TutorTable now Tutor Application Checks for Unreaded Alerts for Some Time Intervals using timer and Fetch Records in Which ReadedAlert Field in Table is False

abas shahen · Answer

hi My friend  ok my scenarion as the following : we have e-learning system  when any Student submit his assignment  an alert appear for Tutor Tell Him  a Student has submit his Tutor

Kirtan Patel · Answer

Hi abas can you tell me in which scenario need this type of code ? explain a lil bit more so that i can better understand your requirement :) thank you