Using ASP.NET tables generated by aspnet_regsql.exe in a SQLite database

Question

I'm building a small ASP.NET MVC site where I want to use SQLite. While I already know how I will be connecting to the database (using DbLinq), I don't understand how to put the ASP.NET tables generated by aspnet_regsql.exe into an SQLite database.

I've used the regsql tool before with SQL Server, but never with SQLite. How do I create them for the SQLite DB?

One strategy that I think might somehow work is:

Use aspnet_regsql.exe to create the tables into an empty SQL Server database
Script all the objects in the database into T-SQL
Apply the T-SQL to the SQLite DB (how?)

Maxim, I have a full provider stack, minus session state, implemented in SQLite if you are interested. — Sky Sanders
– Sky Sanders, Commented Jul 5, 2010 at 8:10
@code poet really? that's wonderful! would save me a bunch of work :) — Maxim Zaslavsky
– Maxim Zaslavsky, Commented Jul 5, 2010 at 8:54
@code have you released that online somewhere, by any chance? — Maxim Zaslavsky
– Maxim Zaslavsky, Commented Jul 9, 2010 at 18:58
m - any luck with the code? I am getting ready to pull that provider stack out and integrate openid, as i see you may also be doing, want to pool resources? — Sky Sanders
– Sky Sanders, Commented Jul 18, 2010 at 1:00

Sky Sanders · Accepted Answer · 2010-07-10 00:50:44Z

2

Take a look at http://salient.codeplex.com

the Web.SQLite directory contains a drop in replacement for the default SQL providers.

It was a proof of concept that turned out ok. It uses EF, so is not as performant as it could be but should service low/medium traffic sites without issue.

You should be able to exclude all other files except that subdirectory and build it in isolation if desired. This will allow you to also trim the references.

Let me know if you have any issues.

answered Jul 10, 2010 at 0:50

Sky Sanders

37.2k9 gold badges71 silver badges91 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

bkaid · Accepted Answer · 2010-07-10 00:56:36Z

1

You could try it with SQL Server Compact Edition 4 which is an embeddable SQL engine like SQLite but has an easier upgrade path if you need to grow it up to SQL Express or SQL Server.

answered Jul 10, 2010 at 0:56

bkaid

52.2k23 gold badges115 silver badges128 bronze badges

Comments

Garett · Accepted Answer · 2010-06-29 07:26:14Z

0

Unfortunately the aspnet_regsql will not work with SQLite, so your strategy is essentially the correct approach. However, I would suggest looking at something like Roger Martin's Gallery Server Pro, which uses SQLite and already has the Membership, Role, and Profile provider tables scripted. You can make use of the script. See Roger's Code Project article from more information.

answered Jun 29, 2010 at 7:26

Garett

16.9k5 gold badges58 silver badges63 bronze badges

Collectives™ on Stack Overflow

Using ASP.NET tables generated by aspnet_regsql.exe in a SQLite database

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related