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