Re: [Firebird-net-provider] VS2008 ADO.NET confusion

[Markus Ostenried]

.NET Compact Framework
https://en.wikipedia.org/wiki/.NET_Compact_Framework

On Mon, Nov 30, 2015 at 3:57 PM, slucas  wrote:
> what is CF?
>
>
> On 11/30/15 2:39 AM, Jiří Činčura wrote:
>> Are you using CF?

--
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
http://pubads.g.doubleclick.net/gampad/clk?id=254741551=/4140
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Exception using Firebird .NET provider and SimpleMembershipProvider in MVC4

[Markus Ostenried]

I managed to write my own membership provider, turns out it wasn't
hard after all -- I just had to find the relevant information out of
everything that's out there :)

In case anyone else needs this information:
I created a new class extending ExtendedMembershipProvider, I
implemented the methods similar to this example:
http://msdn.microsoft.com/en-us/library/6tc47t75(v=vs.100).aspx

For a minimal membership provider it's sufficient to only implement a
few methods:
ValidateUser, CreateUser, GetUser and the properties
MinRequiredPasswordLength, RequiresUniqueEmail.
http://www.codeproject.com/Articles/165159/Custom-Membership-Providers

Regards,
Markus

--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Exception using Firebird .NET provider and SimpleMembershipProvider in MVC4

[Markus Ostenried]

Jiri and Paul,

thanks for your quick repsonses.

Just to confirm, I should do something like this:
http://www.codeproject.com/Articles/165159/Custom-Membership-Providers

Please let me know if I'm finally on the right track :)

Thanks,
Markus


On Wed, Feb 27, 2013 at 5:02 PM, Mercea Paul paul.mer...@almexa.ro wrote:
 Hi Markus

 On 2013.02.27 4:33 PM, Markus Ostenried wrote:
 Hi all,

 I've been using Firebird with Delphi for many years, wrote a few .NET
 applications and have experience in web development.
 However: I never did web development with .NET and my only experience
 with the Firebird .NET provider was a hello world program in Mono on
 Debian a few years ago.

 My task is to write a simple web application using ASP.NET which
 connects to an existing Firebird database. User authentication has to
 use data in an existing table and I need to display data returned from
 a stored procedure. Updating data should call another stored
 procedure.

 I did some research and read quite a few articles about ASP.NET which
 led me to trying out MVC4, also the SimpleMembershipProvider sounded
 like what I need (I'm open for suggestions here).

 I have installed NETProvider-3.0.2.0 and DDEXProvider-3.0.0.0, created
 a new MVC4 Internet application, and in web.config adjusted/added the
 following:
 connectionStrings add name=DefaultConnection connectionString 
 DbProviderFactoriesremove
 invariant=FirebirdSql.Data.FirebirdClient/ add name=Firebird Data
 Provider..

 When I run the application and click on the Register link I get the
 following exception:
 {The ASP.NET Simple Membership database could not be initialized. ...}
inner exception: {Dynamic SQL Error\r\nSQL error code =
 -104\r\nToken unknown - line 1, column 33\r\n.}
with stack trace:
 at 
 FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior
 behavior)
 at 
 FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteDbDataReader(CommandBehavior
 behavior)
 at System.Data.Common.DbCommand.ExecuteReader()
 at WebMatrix.Data.Database.QueryInternald__0.MoveNext()
 at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source)
 at WebMatrix.Data.Database.QuerySingle(String commandText, Object[] args)
 at WebMatrix.WebData.DatabaseWrapper.QuerySingle(String
 commandText, Object[] parameters)
 at WebMatrix.WebData.SimpleMembershipProvider.CheckTableExists(IDatabase
 db, String tableName)
 at WebMatrix.WebData.SimpleMembershipProvider.CreateTablesIfNeeded()
 at 
 WebMatrix.WebData.WebSecurity.InitializeMembershipProvider(SimpleMembershipProvider
 simpleMembership, DatabaseConnectionInfo connect, String
 userTableName, String userIdColumn, String userNameColumn, Boolean
 createTables)
 at 
 WebMatrix.WebData.WebSecurity.InitializeProviders(DatabaseConnectionInfo
 connect, String userTableName, String userIdColumn, String
 userNameColumn, Boolean autoCreateTables)
 at WebMatrix.WebData.WebSecurity.InitializeDatabaseConnection(String
 connectionStringName, String userTableName, String userIdColumn,
 String userNameColumn, Boolean autoCreateTables)
 at 
 MvcApplication1.Filters.InitializeSimpleMembershipAttribute.SimpleMembershipInitializer..ctor()
 in d:\Dinge\Documents\Visual Studio
 2012\Projects\MvcApplication1\MvcApplication1\Filters\InitializeSimpleMembershipAttribute.cs:line
 41

 InitializeSimpleMembershipAttribute.cs:line 41 looks like this:
 WebSecurity.InitializeDatabaseConnection(DefaultConnection,
 UserProfile, UserId, UserName, autoCreateTables: true);

 which is called by:
 public override void OnActionExecuting(ActionExecutingContext filterContext)
 {
// Ensure ASP.NET Simple Membership is initialized only once per app start
LazyInitializer.EnsureInitialized(ref _initializer, ref
 _isInitialized, ref _initializerLock);
 }

 Can you tell me what went wrong here?
 Also, in general, how would I debug an error like this? I'd like to
 know what SQL statement was being executed but I couldn't find it in
 the exception dialog. Are there any log files? How can I step into the
 provider code?

 I'd be thankful for any hints on how to implement my application.
 Maybe I need to start from a different application template or use a
 different membership provider?

 TIA,
 Markus

 You have 2 options:
 1. Use existing Firebird Membership
  a. First create a ASP.Net MVC3 application an close the solution.
  b. Create a ASP.Net MVC4 application.
  c. Copy from MVC3 Account controller and model.
  d. Configure web.config as usual FBMembershipProvider.
 2. Write you own membership.
  You can view the sources from http://aspnetwebstack.codeplex.com/
 as sample.


 HTH,
 Paul MERCEA
 ___

 E-mail: paul.mer...@almexa.ro

 ___


 --
 Everyone hates slow websites. So do we.
 Make your web apps faster

[Firebird-net-provider] Exception using Firebird .NET provider and SimpleMembershipProvider in MVC4

[Markus Ostenried]

Hi all,

I've been using Firebird with Delphi for many years, wrote a few .NET
applications and have experience in web development.
However: I never did web development with .NET and my only experience
with the Firebird .NET provider was a hello world program in Mono on
Debian a few years ago.

My task is to write a simple web application using ASP.NET which
connects to an existing Firebird database. User authentication has to
use data in an existing table and I need to display data returned from
a stored procedure. Updating data should call another stored
procedure.

I did some research and read quite a few articles about ASP.NET which
led me to trying out MVC4, also the SimpleMembershipProvider sounded
like what I need (I'm open for suggestions here).

I have installed NETProvider-3.0.2.0 and DDEXProvider-3.0.0.0, created
a new MVC4 Internet application, and in web.config adjusted/added the
following:
connectionStrings add name=DefaultConnection connectionString 
DbProviderFactoriesremove
invariant=FirebirdSql.Data.FirebirdClient/ add name=Firebird Data
Provider..

When I run the application and click on the Register link I get the
following exception:
{The ASP.NET Simple Membership database could not be initialized. ...}
  inner exception: {Dynamic SQL Error\r\nSQL error code =
-104\r\nToken unknown - line 1, column 33\r\n.}
  with stack trace:
   at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior
behavior)
   at 
FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteDbDataReader(CommandBehavior
behavior)
   at System.Data.Common.DbCommand.ExecuteReader()
   at WebMatrix.Data.Database.QueryInternald__0.MoveNext()
   at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source)
   at WebMatrix.Data.Database.QuerySingle(String commandText, Object[] args)
   at WebMatrix.WebData.DatabaseWrapper.QuerySingle(String
commandText, Object[] parameters)
   at WebMatrix.WebData.SimpleMembershipProvider.CheckTableExists(IDatabase
db, String tableName)
   at WebMatrix.WebData.SimpleMembershipProvider.CreateTablesIfNeeded()
   at 
WebMatrix.WebData.WebSecurity.InitializeMembershipProvider(SimpleMembershipProvider
simpleMembership, DatabaseConnectionInfo connect, String
userTableName, String userIdColumn, String userNameColumn, Boolean
createTables)
   at WebMatrix.WebData.WebSecurity.InitializeProviders(DatabaseConnectionInfo
connect, String userTableName, String userIdColumn, String
userNameColumn, Boolean autoCreateTables)
   at WebMatrix.WebData.WebSecurity.InitializeDatabaseConnection(String
connectionStringName, String userTableName, String userIdColumn,
String userNameColumn, Boolean autoCreateTables)
   at 
MvcApplication1.Filters.InitializeSimpleMembershipAttribute.SimpleMembershipInitializer..ctor()
in d:\Dinge\Documents\Visual Studio
2012\Projects\MvcApplication1\MvcApplication1\Filters\InitializeSimpleMembershipAttribute.cs:line
41

InitializeSimpleMembershipAttribute.cs:line 41 looks like this:
WebSecurity.InitializeDatabaseConnection(DefaultConnection,
UserProfile, UserId, UserName, autoCreateTables: true);

which is called by:
public override void OnActionExecuting(ActionExecutingContext filterContext)
{
  // Ensure ASP.NET Simple Membership is initialized only once per app start
  LazyInitializer.EnsureInitialized(ref _initializer, ref
_isInitialized, ref _initializerLock);
}

Can you tell me what went wrong here?
Also, in general, how would I debug an error like this? I'd like to
know what SQL statement was being executed but I couldn't find it in
the exception dialog. Are there any log files? How can I step into the
provider code?

I'd be thankful for any hints on how to implement my application.
Maybe I need to start from a different application template or use a
different membership provider?

TIA,
Markus

--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Expanding mapping abilities for EF

[Markus Ostenried]

On Sat, Mar 6, 2010 at 15:15, Jiri Cincura disk...@cincura.net wrote:
 As nobody else replied I've added DNET-301 and DNET-302 tickets into
 tracker. And I'll implement these later. It's breaking any existing
 applications, so it shouldn't bother not interested people.

It's breaking any existing applications

I guess this is a typo ^^
Have a nice weekend!

--
Download Intel#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Backup/Restore

[Markus Ostenried]

On Mon, Nov 17, 2008 at 15:19, kixzo [EMAIL PROTECTED] wrote:
 Hello,
 I want to show the Backup and restore Progress to the Users.

 How can I do so, is there any way firebird process returns any values on the
 Progress.

Hi,

I did the following:
I counted the lines returned by doing a verbose backup, and used that
to control a progressbar. Of course that's only an estimate but if you
always store the last total line count and use that for the next
backup/restore cycle then it should be accurate enough.

HTH,
Markus

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider