I hope I am putting this question in the right place because this is more of a content then code question.
I am new to making external list, so my question is, will the external list I have connected to my SQL database table update itself with the new data put into the database, or will I have to run some type of a timer job or something to update the external list. I need to be able to grab data in real time ( if possible ) from my database and load it into the external list.
Is there a way to do this? Also, what would be the best practices to do so?