Database interaction using C# without Entity Framework
<p>I have been given an assignment where I need to display a form, data for which resides in various tables in Sql server. Requirement is strictly to not to use Entity framework or stored procedure. In such case, what are my options? </p>

<p>At the moment I am running some sql queries using SqlCommand object but then things are getting really complicated when it comes to fetching relational data and then allowing user to update it from the form.</p>

<p>What is the best way/approach in Winforms to allow view &amp; edit of relational data?</p>