Course Manager VS 2012 Sample Part 2 – Setting up Data (Andy Kung)

re: Course Manager VS 2012 Sample Part 2 – Setting up Data (Andy Kung)

Michael Herman - Toronto — Sun, 07 Apr 2013 17:49:58 GMT

Thank you for the database schema diagramming tip.

1. Do you also have copies of the design documents that you can share? e.g. business requirements, functional requirements, detailed design, etc?

2. More importantly, what approach(es) did you use in designing and implementing this solution?

3. Did you use TFS tasks, etc. for any of the above?

re: Course Manager VS 2012 Sample Part 2 – Setting up Data (Andy Kung)

andy.kung — Tue, 08 Jan 2013 21:16:42 GMT

@Don - Thank you for the feedback! Some of the table columns are generated by LightSwitch. For example, when you create a relationship between Enrollment and Student, LightSwitch automatically creates the foreign keys for you. You will see Enrollments in the Student table indicating that each student may have multiple enrolments. Perhaps that's the reason you see a mismatch between the walkthrough and the completed sample. If you follow the walkthrough from scratch, you should end up with exactly the same configuration as the sample.

I also verified that the code from the walkthrough are available in both VB and C# samples. We will work on inserting the corresponding C# snippets in the walkthrough. In the mean time, you should be able to find the C# code in the sample.

Here is a tutorial for getting the database schema diagram in Visual Studio. blogs.msdn.com/.../how-to-connect-to-and-diagram-your-sql-express-database-in-visual-studio-lightswitch.aspx.

re: Course Manager VS 2012 Sample Part 2 – Setting up Data (Andy Kung)

Don — Tue, 01 Jan 2013 13:56:47 GMT

The table names and column names (Fields & Properties) in this article do not match the tables / columns provided in the example C# solution.

Also, as asked by another person, is this series of articles available with C# code, instead of VB code - aside from the actual downloaded files? I would like to walk through the entire article series actually performing each step. But I use C#, not VB.

Thank you.

re: Course Manager VS 2012 Sample Part 2 – Setting up Data (Andy Kung)

Don — Tue, 01 Jan 2013 13:50:01 GMT

Where is the option in VS 2012 Pro / LightSwitch to display a database schema diagram?

Thank you.

re: Course Manager VS 2012 Sample Part 2 – Setting up Data (Andy Kung)

Updating — Fri, 31 Aug 2012 18:51:49 GMT

You use a code for updating with the VB sample. However, when trying to use C#, there is a problem with the code, and I noticed on the C# sample, you do not have the code. How would we update the records automatically in C#.