EffiProz - A Pure C# Database

Updated Wiki: Home

igloobone — Wed, 17 Mar 2010 15:09:30 GMT

EffiProz pure C# database with Entity Framework Provider

EffiProz features and SQL dialect is very similar to HSQLDB 1.9/2.0 http://hsqldb.org/doc/2.0/guide/ch07.html

*Howto create a CLR stored function http://blog.effiproz.com/2010/03/clr-functions-with-effiproz-database.html

More VS2010 Data Designer support screenshots

Updated Wiki: Documentation

igloobone — Wed, 17 Mar 2010 15:08:58 GMT

HOWTOs

Updated Wiki: Documentation

igloobone — Wed, 17 Mar 2010 15:05:28 GMT

HOWTOs

*Howto create a CLR stored function http://blog.effiproz.com/2010/03/clr-functions-with-effiproz-database.html

New Post: Effiproz and Silverlight

igloobone — Wed, 17 Mar 2010 08:35:58 GMT

EffiProz doesn't support Silverlight 4 specific features.

We try to get new features included as soon as possible but there is no set time frame.

Thanks.

New Post: Effiproz and Silverlight

lopezan — Wed, 17 Mar 2010 07:09:01 GMT

Hi,

in SL4 I can save the DB in special folders, like MyDocuments. How can I do this?

Thanks.

New Post: Effiproz and Silverlight

igloobone — Wed, 17 Mar 2010 01:03:04 GMT

1) Though I haven't tried, I guess Silverlight 3 version will work fine without modifications on Silverlight 4.

2) Did you try? I see no reason why it will not work.

3) Should work on any environment that support Silverlight

New Post: Effiproz and Silverlight

lopezan — Tue, 16 Mar 2010 18:01:54 GMT

Hi,

I have 3 questions:

1) When will be released an EffiProz version for Silverlight 4?

2) EffiProz works in Out-Of-Browser Silverlight application?

3) Effiproz works in MACOSX environment?

Thanks.

Angelo.

New Post: I can not open project

igloobone — Sun, 14 Mar 2010 02:19:30 GMT

CF projects are in the trunc.... not in EffiProz-CF branch. Checkout from change set 52621, as CF build may be broken in later changesets.

project file names are,

CoreCF.csproj for Core, System.Data.EffiProzCF.csproj for provider and TestCF.csproj for Test.

solution file may be out of synch. create your own solution.

New Comment on "Howto create a in-memory Database with EffiProz"

undecided — Sat, 13 Mar 2010 18:06:25 GMT

I get this error: 'Specified connection type is not valid.' when using the connString specified above. Can you assist?

New Post: I can not open project

Webbi — Sat, 13 Mar 2010 16:36:35 GMT

Pardon me, but I confused.

I download EffiProz-54964, that has EffiProz-CF. I try to open it by VS 2008 Pro. VS2008 show error which solution created by new version.

I use VS2010 RC Pro, But VS can not opened it.

Please help me.

Please say me correct version of effiproz, which I must download it to release CF for wince 5.0

thanks

New Post: I can not open project

igloobone — Fri, 12 Mar 2010 16:14:32 GMT

We use VS2008 for development. try to open with VS2008.

New Post: I can not open project

webbi — Fri, 12 Mar 2010 06:29:52 GMT

According to Need Comapct Framework sample discussion, I need compact version release for WinCe. Then I try to release myself.

I downloaded VS2010 RC. After installing, I try to open EffiProz-CF solution. VS didn't open projects. I got belew error:

Unable to open D:\.....\EffiprozDBSetup.vdproj.

Also

One or more project in the solution were not loaded correctly. (All project didn't load)

In Output windows show:

D:\Win Projects\Visual Studio 2010\EffiProz-54964\EffiProz-CF\EffiProzDBServer\EffiProzDBServer.csproj : error : Unable to read the project file 'EffiProzDBServer.csproj'.
D:\Win Projects\Visual Studio 2010\EffiProz-54964\EffiProz-CF\EffiProzDBServer\EffiProzDBServer.csproj: The project file could not be loaded. Could not find a part of the path 'D:\Win Projects\Visual Studio 2010\EffiProz-54964\EffiProz-CF\EffiProzDBServer\EffiProzDBServer.csproj'.

All project in solution are unavilabe.

What is wrong? What I must do to I can open solution?

New Post: Need Comapct Framework sample

igloobone — Sat, 06 Mar 2010 12:10:44 GMT

Those dlls are compiled on Windows Mobile 5 smartphone sdk. You may need to recompile source on WinCE 5.0.

New Post: Need Comapct Framework sample

Webbi — Sat, 06 Mar 2010 05:11:11 GMT

Tanks for quick response.

I used same connection string, Which had used on Win app.

I use it on real device with Wince 5.0.

I add 2 Dlls to reference :

EffiProz.CoreCF.dll

System.Data.EffiProzCF.dll

New Post: Need Comapct Framework sample

igloobone — Sat, 06 Mar 2010 02:31:11 GMT

compact framework connection string is identical to regular connection string.

make sure you are linking with CF Dlls. what emulator are you using? Do you get a stacktrace?

New Post: Need Comapct Framework sample

Webbi — Fri, 05 Mar 2010 19:11:44 GMT

I use EffiProz on VB.Net application. Work great.

But I try to use Compact framework version. It didn't work.

I need connection string that I must use for open connection.

New Post: EffiProzDBConnection Class Missing???

igloobone — Mon, 15 Feb 2010 07:22:52 GMT

Use EfzConnection class.

New Post: EffiProzDBConnection Class Missing???

UTtheGeek — Mon, 15 Feb 2010 01:28:01 GMT

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Data.EffiProz;

using System.Data.Common;

namespace EffiProz

{

class Program

{

static void Main(string[] args)

{

string connString = "Type=Memory ; Data Source =TestDB; User=sa; Password=;";

string sql = "CREATE TABLE TEST(ID INT, NAME VARCHAR);";

using (DbConnection conn = new EffiProzDBConnection(connString))

{

DbCommand command = conn.CreateCommand();

command.CommandText = sql;

conn.Open();

command.ExecuteNonQuery();

command.CommandText = "INSERT INTO TEST(ID , NAME) VALUES(1,'BIRD');";

command.ExecuteNonQuery();

command.CommandText = "SELECT * FROM TEST;";

DbDataReader reader = command.ExecuteReader();

System.Diagnostics.Debug.WriteLine(reader.FieldCount);

while(reader.Read())

{

Console.WriteLine("ID= "+ reader.GetInt32(0)+ " Name=" + reader.GetString(1));

}

Console.ReadKey(true);

}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Data.EffiProz;

using System.Data.Common;

namespace EffiProz

{

class Program

{

static void Main(string[] args)

{

string connString = "Type=Memory ; Data Source =TestDB; User=sa; Password=;";

string sql = "CREATE TABLE TEST(ID INT, NAME VARCHAR);";

using (DbConnection conn = new EffiProzDBConnection(connString))

{

DbCommand command = conn.CreateCommand();

command.CommandText = sql;

conn.Open();

command.ExecuteNonQuery();

command.CommandText = "INSERT INTO TEST(ID , NAME) VALUES(1,'BIRD');";

command.ExecuteNonQuery();

command.CommandText = "SELECT * FROM TEST;";

DbDataReader reader = command.ExecuteReader();

System.Diagnostics.Debug.WriteLine(reader.FieldCount);

while(reader.Read())

{

Console.WriteLine("ID= "+ reader.GetInt32(0)+ " Name=" + reader.GetString(1));

}

Console.ReadKey(true);

}

Source code checked in, #54964

_paperino — Thu, 28 Jan 2010 22:34:12 GMT

Fix a datetime bug Changed the behavior when the connection gets closed from a Shutdown to Checkpoint and renamed the method

New Post: Unit Testing this Database

igloobone — Mon, 18 Jan 2010 01:48:40 GMT

Thanks for the Tips!