[Firebird-net-provider] Entity Framework, Get Column Information gives specified type is not supported
Entity Framework in Model Browser -Add Function Import for Stored procedure when clicking Get Column Information I get exception An exception of type System.NotSupportedException occured while attempting to get columns information. The exception message is: The specified type is not supported by this selector. and this is for all stored procedures. how to solve it? -- Virtualization Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] upgrading to 2.7.0 Failure adding assembly to the cache:
today tried to upgrade from 2.6 to 2.7.0 but I am getting error in GACUTIL -i FirebirdSql.Data.FirebirdClient.dll Failure adding assembly to the cache: This assembly is built by a runtime newer than the currently loaded runtime and cannot be loaded. I have Windows XP, .NET 4. how to solve it? how to do it correctly? thanks. -- Virtualization Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Storing and retrieving images from Firebird BLOB field
for a new web app I need to store huge amount of images. I gave googled and found that to store images in db is the right way :) http://www.firebirdnews.org/?p=1906 but how to store and retrieve images efficiently into Firebird BLOB field with ASP.NET C# code? I would very much appreciate a code sample- especially for retrieve (thumbnail and full size of same retrieve)? -- Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex infrastructure or vast IT resources to deliver seamless, secure access to virtual desktops. With this all-in-one solution, easily deploy virtual desktops for less than the cost of PCs and save 60% on VDI infrastructure costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] same connection for VS SqlDataSource, controls and FB commands
I have been now reading MSDN and understand that the way to go is always
to open/close connection as the pool itself takes care of it.
with help of sample in MSDN I got this to work
String fullname = TxtBox_name.Text;
String email = TxtBox_email.Text;
String phone = TxtBox_phone.Text;
String pwd = TxtBox_pwd.Text;
System.Configuration.Configuration rootWebConfig
=System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration(/MyWebSiteRoot);
System.Configuration.ConnectionStringSettings connString;
if (rootWebConfig.ConnectionStrings.ConnectionStrings.Count
0)
{
connString
=rootWebConfig.ConnectionStrings.ConnectionStrings[ConnectionString2];
if (connString != null)
{
using (FbConnection conn = new
FbConnection(connString.ConnectionString))
{
conn.Open();
using (FbCommand cmd = conn.CreateCommand())
{
cmd.CommandText = select * from
SP_PARTY_INS (?, ?, ?, ?, ?);;
cmd.Parameters.Add(@email, email);
cmd.Parameters.Add(@name, fullname);
cmd.Parameters.Add(@websiteurl, null);
cmd.Parameters.Add(@phone, phone);
cmd.Parameters.Add(@pwd, pwd);
int i = (int)cmd.ExecuteScalar();
if (i != null)
{
Button2.Text = New user id: + i;
}
}
conn.Close();
}
}
}
however is there any advantages of using FbCommand over just doing with
Visual Studio SqlDataSource command? because this code is a lot shorter
String fullname=TxtBox_name.Text;
String email=TxtBox_email.Text;
String phone=TxtBox_phone.Text;
String pwd = TxtBox_pwd.Text;
SqlDataSource1.SelectParameters.Add(@email, email);
SqlDataSource1.SelectParameters.Add(@name, fullname);
SqlDataSource1.SelectParameters.Add(@websiteurl, null);
SqlDataSource1.SelectParameters.Add(@phone, phone);
SqlDataSource1.SelectParameters.Add(@pwd, pwd);
DataView dv =
(DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty);
int i = (int)dv.Table.Rows[0][0];
if (i != null)
{
Button1.Text = New user id: + i;
}
is there any difference in performance? or some other advantage?
On 18.12.2011 11:19, Jiri Cincura wrote:
On Sun, Dec 18, 2011 at 12:20 AM, Net Newbienetfireb...@gmail.com wrote:
how to do this in a better way?
Look at connection pooling topic at MSDN.
--
Learn Windows Azure Live! Tuesday, Dec 13, 2011
Microsoft is holding a special Learn Windows Azure training event for
developers. It will provide a great way to learn Windows Azure and what it
provides. You can attend the event by watching it streamed LIVE online.
Learn more at http://p.sf.net/sfu/ms-windowsazure
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
