DataBase with Visual Studio Express 2012 for Windows 8

ADPYvette

New member
Joined
Sep 5, 2013
Messages
3
Programming Experience
Beginner
I am building an application that needs to access a database. I installed the SQLite.net, made references to SQLite for Windows Runtime and Microsoft Visual C++ Runtime Packages. Now, how do I connect to the database? In other words, what are the Visual Basic codes? Note that I do not see a DataSet or DataGridView in the tools menu like there is in Visual Basic 2008 that I am more familiar with I am using Visual Studio Express 2012 for Windows 8 (not the desktop version) and I code in Visual Basic.
 

jmcilhinney

VB.NET Forum Moderator
Staff member
Joined
Aug 17, 2004
Messages
14,717
Location
Sydney, Australia
Programming Experience
10+
I have to confess, I haven't used VS for Windows 8 but I have used the Windows Phone version. In that case, I've used LINQ to SQL to create and work with a SQL Server CE database. Is that a viable option for you or do you have to use SQLite?
 

ADPYvette

New member
Joined
Sep 5, 2013
Messages
3
Programming Experience
Beginner
I have to confess, I haven't used VS for Windows 8 but I have used the Windows Phone version. In that case, I've used LINQ to SQL to create and work with a SQL Server CE database. Is that a viable option for you or do you have to use SQLite?


I don't necessarily have to use SQLite. In fact, all I want is a database so, any type would be ok. If you think LINQ to SQL would work then, I would be very happy if you could gave me the procedure.
 

jmcilhinney

VB.NET Forum Moderator
Staff member
Joined
Aug 17, 2004
Messages
14,717
Location
Sydney, Australia
Programming Experience
10+
Hmmm... I may have given you a bum steer there. I just created a new Store project and there's no LINQ to SQL item template available. I have to admit, I haven't really researched Windows 8 development yet, so I don't know all the details. I have heard that you're supposed to use web services for data access, so maybe the idea is that you create a web service and it can use LINQ to SQL or ADO.NET or whatever. When I do get into Windows 8 development, this course will be one of the first places I look for information and this lesson relates to data access:

https://www.facultyresourcecenter.c...ent-for-Modern-UI-Module-7.aspx?c1=en-us&c2=0
 

Latest posts

Top Bottom