StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>You can't directly connect to a SQL Server, because of the Metro-Apps-Sandbox concept. They only can comunicate with a server through a service. The only way around this limitation that I know of is a <a href="http://code.msdn.microsoft.com/windowsapps/Sqlite-For-Windows-8-Metro-2ec7a882" rel="nofollow noreferrer">SQLite</a> integration into Windows 8 Apps.</p> <p>In my opinion the best way (if you use Visual Studio) is the <a href="http://en.wikipedia.org/wiki/Entity_Framework" rel="nofollow noreferrer">EntityFramework</a>. It seems a bit complex at the beginning, but the <a href="https://en.wikipedia.org/wiki/Object-relational_mapping" rel="nofollow noreferrer">ORM</a> really helps while developing (less mistakes through intellisens, more security against injections). Then you wrap it up into a <a href="http://en.wikipedia.org/wiki/WCF_Data_Services" rel="nofollow noreferrer">WCF Data Service</a> and you are ready to use any SQL-Database in your application.</p> <blockquote> <p>The Entity Framework enables developers to work with data in the form of domain-specific objects and properties, such as customers and customer addresses, without having to concern themselves with the underlying database tables and columns where this data is stored. With the Entity Framework, developers can work at a higher level of abstraction when they deal with data, and can create and maintain data-oriented applications with less code than in traditional applications</p> </blockquote> <p>You can decide between two ways:</p> <ol> <li>Model first - Design your DB inside Visual Studio or SQL Server Management Studio </li> <li>Code first - Design your DB based on Classes</li> </ol> <p>However there are some downsides:</p> <ul> <li>If you use Windows Azure you cannot use n:m relationship direct because of some restrictions to Azure Databases. </li> <li>You need to call the database async for Windwos 8 development. Therefore, there are always some confusing between the old client side use of EF and the new use in Windows 8.</li> </ul> <p><a href="http://msdn.microsoft.com/en-us/data/ef.aspx" rel="nofollow noreferrer">Here</a> is the Page of the EF-Project. You should start there to dive into it.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload