[Mono-aspnet-list] [Mono-list] sqlite questions?

Dale E. Moore daleemoore at gmail.com
Tue Nov 3 09:29:56 EST 2009


I'm using the default asp.net membership provider; which works fine in
monodevelop, but; does not find the App_Data/aspnetdb.sqlite database when
copied to TEST. I copied the mono connectionString, and membership
definition into my web.config but then could never login even from
monodevelop.

I'm missing something in the membership setup in web.config, I think.

On Tue, Nov 3, 2009 at 8:21 AM, Joe Audette <joe.audette at gmail.com> wrote:

> If you are using mojoPortal then you don't have to worry about this,
> the mojoMembership just talks to business objects which talk to data
> objects which already know their connection string from the
> appSettings.
>
> If you are using some other membership provider then you probably need
> to add a ConnectionString section to your web.config and add the
> connection string there with a name expected by or configured on the
> provider. However I don't know if there is a membership provider
> specifically for sqlite in Mono, maybe there is, there would have to
> be some scripts to create the appropriate tables in the sqlite
> database.
> Do a little googling about the ConnectionString section of Web.config.
>
>
> Hope it helps,
>
> Joe
>
> On Tue, Nov 3, 2009 at 9:14 AM, Dale E. Moore <daleemoore at gmail.com>
> wrote:
> > Dear Joe;
> >
> > It's so good to 'hear your voice' here!
> >
> > I copied the DEV project to a TEST site and everything works, except the
> > Forms Authentication; I can't login and I can't seem to tell sqlite where
> > the Membership database is located. Thanks for your thoughts on growth; I
> > will probably move to PostgreSQL if anybody other than me ever wants the
> > functionality.
> >
> > Debugging my NewValues reverted to OldValues issue is still on my to do
> > list; thanks for the encouragement;
> > Dale
> >
> >
> >
> >
> > On Tue, Nov 3, 2009 at 5:51 AM, Joe Audette <joe.audette at gmail.com>
> wrote:
> >>
> >> Hi Dale,
> >>
> >> The latest mojoPortal from our svn trunk repository is pre-configured
> >> to use SQLite in MonoDevelop using mojoportal.mds solution.
> >> I changed the default db configuration from pgsql recently just
> >> because its zero configuration, we inlcude a sqlite database and it
> >> just works.
> >> You can produce a package and deploy it to production including the
> >> pre-populated SQLite database.
> >> However, whether you would use SQLite for a production site/app
> >> depends a lot on the app and how many users it will have. SQLite is
> >> very fast but there is only 1 connection whereas pgsql and others have
> >> a connection pool. So if the site/app gets a lot of traffic it
> >> probably won't stand up well because each request is taking turns with
> >> the one connection. So it can work well for a few users but it does
> >> not scale real well to heavy web traffic.
> >>
> >> Hope it helps,
> >>
> >> Joe
> >>
> >> On Tue, Nov 3, 2009 at 4:01 AM, Marek Habersack <
> grendel at twistedcode.net>
> >> wrote:
> >> > Dale E. Moore wrote:
> >> >> Is this a good place to ask questions about sqlite? Can somebody
> please
> >> >> tell me where to go;)
> >> > On SQLite itself - no, in relation to Mono/ASP.NET - yes.
> >> >
> >> >> Has everybody (or anybody) worked with monodevelop to put together an
> >> >> asp.net <http://asp.net> application that uses an sqlite database
> that
> >> >> they then put into production?
> >> > I don't use MonoDevelop, but for a production application which can
> use
> >> > SQLite as an option, see
> >> > BlogEngine.NET.
> >> >
> >> > marek
> >> > _______________________________________________
> >> > Mono-aspnet-list mailing list
> >> > Mono-aspnet-list at lists.ximian.com
> >> > http://lists.ximian.com/mailman/listinfo/mono-aspnet-list
> >> >
> >>
> >>
> >>
> >> --
> >> Joe Audette
> >> Software Solutions Architect
> >> Source Tree Solutions, LLC
> >> PO Box 621861
> >> Charlotte, NC 28262
> >> 704.323.8225
> >> joe.audette at gmail.com
> >> http://www.mojoportal.com
> >> http://twitter.com/joeaudette
> >
> >
>
>
>
> --
> Joe Audette
> Software Solutions Architect
> Source Tree Solutions, LLC
> PO Box 621861
> Charlotte, NC 28262
> 704.323.8225
> joe.audette at gmail.com
> http://www.mojoportal.com
> http://twitter.com/joeaudette
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ximian.com/pipermail/mono-aspnet-list/attachments/20091103/bf078c48/attachment-0001.html 


More information about the Mono-aspnet-list mailing list