I created a new Visual Studio Setup project with VS 2008. I use it to install SQLExpress. The installatino of SQLExpress works fine when I do it manually outside of the installer. But when I install, I get an error in SQL Express with permissions. I found out that it's because the SQLExpress process is running as the System account when I run it from my setup project. I tried starting
我用VS 2008创建了一个新的Visual Studio安装项目。 我用它来安装SQLExpress。 当我在安装程序之外手动完成时,SQLExpress的安装程序正常工作。 但是当我安装时,我在SQL Express中遇到了一个有权限的错误。 我发现这是因为当我从我的安装项目运行它时,SQLExpress进程作为系统帐户运行。 我试图通过自定义操作和通过在通过Process.Start安装模块后运行的C#代码启动该过程。 但是他们都以系统帐户的身份运行SQLExpress
I'm trying to create a stacked bar chart in Excel where the value axis has dates. I need the distance between ticks to be 1 month (not 30 days, not 31 days: 1 month). I find that, while I can use the format unit option and date cells to show month and year in the value axis, the distance between ticks isn't 1 month and so the bars don't have the length they should, and I can't c
我试图在Excel中创建一个数值轴有日期的堆积条形图。 我需要蜱之间的距离为1个月(不是30天,不是31天:1个月)。 我发现,虽然我可以使用格式单位选项和日期单元格来显示数值轴上的月份和年份,但蜱之间的距离不是1个月,因此酒吧没有它们应该的长度,我可以不会改变这一点。 我能做的最好的事情是将主要和次要单位设置为30,因此他们可以获得30天的距离,但正如我所说,这与图表可视化有关。 有什么方法可以创建日期轴作
I want to use a standard date format that displays date, month and year in the standard regional settings of the pc. However I could only find "D" which lists day along with Date-Month-Year. Is there any way I can remove the day from it or any other way to get my desired output? DateTime date1 = new DateTime(2008, 4, 10); Console.WriteLine(date1.ToString("D", Cultu
我想使用标准的日期格式,在PC的标准区域设置中显示日期,月份和年份。 但是,我只能找到“D”,其中列出了日期和日期 - 月 - 年。 有没有什么办法可以从它或其他任何方式中删除我想要的输出? DateTime date1 = new DateTime(2008, 4, 10); Console.WriteLine(date1.ToString("D", CultureInfo.CreateSpecificCulture("en-US"))); // Displays Thursday, April 10, 2008 注意:我不想使用自定义格式(d
I'm trying to calculate directory sizes in a way that divides the load so that the user can see counting progress. I thought a logical way to do this would be to first create the directory tree then do an operation counting the length of all the files. The thing that comes to me as unexpected is that the bulk of time (disk I/O) comes from creating the directory tree, then going over the Fi
我试图以分开负载的方式计算目录大小,以便用户可以看到计数进度。 我认为这样做的一个合乎逻辑的方法是首先创建目录树,然后进行计算所有文件长度的操作。 我意想不到的是,大部分时间(磁盘I / O)来自创建目录树,然后几乎立即通过FileInfo[]来实现,而实际上没有磁盘I / O。 我尝试过使用Directory.GetDirectories() ,简单地创建目录名称的字符串树,并使用DirectoryInfo对象,并且两种方法仍然占用大部分I / O时间(
I have a query like this var orderedQueryable = this.participationRequests .Fetch(x => x.CommunityEvent) .Fetch(x => x.CommunityMember) .ThenFetch(x => x.User) .Where(x => x.CommunityMember.Community.Id == communityId) .OrderBy(x => x.CreateDate); The where clause needs to be after fetch due to this bug. The problem is
我有这样的查询 var orderedQueryable = this.participationRequests .Fetch(x => x.CommunityEvent) .Fetch(x => x.CommunityMember) .ThenFetch(x => x.User) .Where(x => x.CommunityMember.Community.Id == communityId) .OrderBy(x => x.CreateDate); 由于此错误,where子句需要在获取后进行。 问题是,thouse Fetch调用发出其他连接。 在
I am running into an issue with an NHibernate filter. It works great until I do a left outer join to the object. For example, Deal references PurchaseItem, but PurchaseItem has a CompanyId filter applied. If I want to query deal with a left join to PurchaseItem, the CompanyId filter is applied in the WHERE clause, causing nothing to return. Is there a way to apply the filter at the join in
我遇到了一个NHibernate过滤器的问题。 它工作得很好,直到我做一个左外连接到对象。 例如,Deal引用PurchaseItem,但PurchaseItem应用了CompanyId过滤器。 如果我想要查询与PurchaseItem的左连接的处理,则CompanyId筛选器应用于WHERE子句中,从而不会返回任何内容。 有没有办法在连接而不是在where子句处应用过滤器? 通过使用此过滤条件解决此问题:“CompanyId是NULL或CompanyId =:companyId” 这是可以的,因为
I'm trying to join a table to retreive and set a property on a POCO. Here's the scenario... *NOTE - An application can belong to many user sessions. UserSession (Table) UserSessionId PK ApplicationId FK UserName Application (Table) ApplicationId PK Name UserSession (Poco) string UserName get; string ApplicationName get; I've tried a join like this: Join("Application", j =&
我试图加入一张表来检索并设置一个POCO的财产。 这是场景...... *注 - 应用程序可以属于许多用户会话。 UserSession(表) UserSessionId PK ApplicationId FK UserName 应用(表) ApplicationId PK Name UserSession(Poco) string UserName get; string ApplicationName get; 我尝试过这样的连接: Join("Application", j => j.Inverse().KeyColumn("ApplicationId").Map(x => x.ApplicationName)); 但是
I recently had to uninstall and reinstall the MySQL suite, including the connectors for MySQL. Apparently, the .NET connector never properly uninstalled and when I went to reinstall the connectors, the .NET connector didn't appear in the installer package for MySQL. I went through a myriad of steps to try and remove the package. I used the Programs and Features uninstall options, CMD msi
我最近不得不卸载并重新安装MySQL套件,包括MySQL的连接器。 显然,.NET连接器从未正确卸载,并且当我重新安装连接器时,.NET连接器未出现在MySQL的安装程序包中。 我经历了无数的步骤尝试去除包装。 我使用了程序和功能卸载选项,CMD msi删除选项,从注册表中删除与注册表中的连接器相关的每个条目,以及MySQL msi软件包中的内置删除/修复/更改工具。 我终于从程序列表中消失了程序,但是当我尝试再次安装程序包时,它仍
The image below describes my problem. There is no option for MySQL Server although i have installed the MySQL connector for Visual Studio 2012. I want to use Entity model and i am stacked here. Any idea why is this happening? You have to use MySQL for Visual Studio: http://dev.mysql.com/tech-resources/articles/mysql-installer-for-windows.html Because since version 6.7 MySql connector do
下面的图片描述了我的问题。 虽然我已经安装了Visual Studio 2012的MySQL连接器,但没有MySQL服务器的选项。我想使用实体模型,并将其堆叠在此处。 任何想法为什么发生这种情况? 你必须为Visual Studio使用MySQL: http://dev.mysql.com/tech-resources/articles/mysql-installer-for-windows.html 因为从版本6.7开始,MySql连接器不再包含用于Visual Studio集成的MySQL
My schema, table and varchar columns have a collation utf8 - utf8_turkish_ci and I am trying to insert turkish specific characters into a varchar(200) column. My query is like below insert into categories (name) values ('ışığı') When I execute this query via MySql Workbench everything is fine. But when I execute this query using MySqlClient ışığı is inserted as isigi . Somehow turkish char
我的模式,表和varchar列有一个排序规则utf8 - utf8_turkish_ci ,我试图将土耳其特定字符插入varchar(200)列。 我的查询如下所示 insert into categories (name) values ('ışığı') 当我通过MySql Workbench执行这个查询时,一切都很好。 但是,当我使用了MySqlClient执行这个查询ışığı插入为isigi 。 不知何故,土耳其的字母迷上了。 MySqlConnection conn = new MySqlConnection(connStr); conn.Open(); MySqlComma